![]() Now, I am creating a bar chart using the same data we used to create the pie chart.Ĭharting the same data different ways can provide you with a different perspective that may help you discover different insights in the data. If you try to graph too much data in a pie chart it looks like this, not very useful. I scroll down a little, click the bottom right-hand corner of the chart, and drag it up and to the left to make it smaller.ĭifferent data displays better in different types of charts. I click the chart hold down the left mouse button, and drag to move it. I am going to move and resize the chart, so it displays without having to scroll, which will also make it easier to customize (something we'll look at in the next video.) ![]() In this example, those are the Sales figures in cells B2 through B5. You can chart only one data series with a pie chart. I'll show you how to create a chart that isn't a Quick Analysis option, shortly.Ĭlick the Pie option, and your chart is created. To create a pie chart, select the cells you want to chart.Įxcel displays recommended options based on the data in the cells you select, so the options won't always be the same. ![]() ![]() In this video, we are going to create pie, bar, and line charts.Įach type of chart highlights data differently.Īnd some charts can't be used with some types of data. We created a clustered column chart in the previous video.
0 Comments
Leave a Reply. |