Imagine this! You're sitting in front of your computer, looking at a colossal spreadsheet. There are hundreds of rows and columns, and you're trying to make sense of it all. It's time to let Excel do the work for you. In this tutorial, I'll show you how to create some really cool charts, with data from a fictitious company's budget.
Check out our 24 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
00:00 Introduction to Excel Charts Advanced
00:57 How to create a Chart in Excel
02:20 How to use Format Data Series Function in Excel
03:08 How to Reverse the Categories in Excel Chart
04:17 How to use Data Label in Excel Chart
08:11 How to Add borderline or dash line in Excel Chart
08:56 How to Change Y-axis Values in Excel Chart
09:41 How to Remove Gridlines in Excel Charts
10:16 Dynamic Title Format in Excel Chart
12:38 How to use Pie Chart in Excel
15:51 How to use Treemap Chart in Excel
16:44 How to Add Labels in Treemap Chart
17:49 Treemap for category and sub-category in Excel
19:31 Negative Points of Treemap in Excel
21:04 Why is a two-axis chart needed?
22:19 How to use a two-axis chart in Excel
23:41 How to change outline in Excel Chart
24:16 How to use Marker Function in Excel
26:14 How to create a Thermometer Chart? - two styles in Excel
29:31 How to Data Sort in Excel
30:13 Thermometer Chart example no. 2
31:14 How to use Gap Width Function in Excel
31:58 How to change the axis in Excel Thermometer Chart
35:17 How to Insert Average line in Excel Chart
36:36 How to use Data Source Pannel in Excel
37:24 How to change Column Chart to Line Chart in Excel
38:34 How to create Automatic Negative Color in Excel Chart
39:19 Excel Horizontal Data Sort Hidden Trick
40:06 How to Change Color if negative in Excel Chart
41:16 How to Change Label in Excel Chart
42:29 How to use Waterfall Chart in Excel
48:54 Configure using "Select Data" in Excel Chart
52:05 How to use Stacked Column Chart in Excel
53:02 How to use Switch Row/Column Stacked Column Chart in Excel
53:43 How to change a Category name in Stacked Column Chart in Excel
54:35 100% Stacked Bar in Excel
58:00 How to Change Color in Excel 100% Stacked Bar
59:05 Example of 100% Stacked Bar in Excel
01:01:58 Rebase start value as 100 ('Normalise' the variables)
01:04:08 How to use Indexing in Excel
01:05:29 How to Insert Line Chart in Excel
15 Excel CHARTS recommended by Rishabh | Excel in Hindi
#excelcharts #businessdashboard #excelinhindi
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
14 июл 2024