Exploring Chart Types in Excel 2016

Exploring Chart Types in Excel 2016 (Video transcript)

There are many chart types to select from that are going to work on different data types.

Let’s use our sample data to explore the different chart types. Let’s first select the data and Alt+F1 for quick. This will create a default chart, that is clustered chart. Most of the time it will be the best chart. It shows the data clearly and what is going on here.

We can change these chart types, we have chart types option here. We can change it to a stacked column, 3-D clustered column. We can try this. This may not be the best chart but we can see how it looks.

We can try also the bar graphs. Go to chart type and change to bar graphs. We can change the styles available across here. We can try the line graphs also. This may the best chart type for this data. Because we have a time variation. It shows how sales are changing from time to time.

We can try also the pie chart. A pie chart can only deal with a limited amount of data. let’s go to chart types and select the pie chart. We have this all data but deals with only the national sales data. So Pie chart is not the best fit for this type of data.

There are also other chart types. Area chart with its variations, XY or scatter chart, Stock, Surface, Radar chart, TreeMap, Sunburst chart, Histogram with its Pareto variations, Box & Whisker chart, Waterfall chart, and Combo chart. We can combine two charts into one.

In the next lecture will be working on formatting charts.

Add Comment