5 Most Used Charts in Excel

Top 5 Charts Used in Excel

You can create many type of charts in excel to highlight, showcase and represent data and I have tried to explain how to create the most used charts in excel

Most used charts in excel are

1. Bar Chart
2. Pie chart
3. Line Chart
4. Column chart
5. Combo Chart 

Now let’s see how to use each of these charts in excel  

Bar Chart – This chart to visually compare values across a few categories when the chart shows duration or the category text is long.  To understand  how to make a Bar chart please check this video

Pie Chart – Use this chart to show the breakup of contributors when the total is 100% like how much 

each person has contributed in total sales of a month. To understand  how to make a Pie chart please check this video 

http://myelesson.org/excel-training-videos/create-pie-chart-in-excel-hindi/ 

Line Chart – Use this chart to map trends over time like days, months, years. Line charts are very effective in delivering the results in a very minimalist manner.To understand  how to make a Line chart please check this video 

Column Chart -  Use this chart to visually compare values across  categories. To understand  how to make a Column chart please check this video http://myelesson.org/excel-training-videos/chart-column-type-hindi/

Combo Chart - this chart can used to display multiple type of info together, its an hybrid chart which can display 2 type of chart elements in one chart like combining a Column chart with a Line chart . To understand  how to make a Combo Chart please check this video  http://myelesson.org/excel-training-videos/create-combo-chart-in-excel/

If you want to watch watch more videos to learn MS excel then please visit http://www.myelesson.org/excel-training-videos/