I'm going to click this one and it puts a chart right in the middle of the worksheet. I don't want an exploded pie or a pie of pie and certainly not a 3D pie, because those can distort the data, with the way that they create angles. To create the chart, I'm going to select any cell in this table, and on the Ribbon, I'll go to the Insert tab, and click PieĪnd I'm going to select this first pie chart, which is just a simple pie chart. On this sheet, I have the names of four regions, and in the column to the right,the numbers which represent the sales in each of those regions.Ī pie chart can only show one set of numbers, so we couldn't compare year to year for each region, but we can see the total sales for the current year. It might be easier to compare the values, if you create a bar chart such as this one, which easily shows the difference between each region, or in a column chart like this one.īut if you need to create a pie chart, we'll see the steps for creating one that's easy to read, and presents the data as clearly as possible. With a pie chart in Excel, you can see a representation of the total amount, and then the percentage that each value has of that total.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |