You can use a pie chart to show the relationship or proportion of parts to a whole. Each slice of the pie shows what percent that slice contributes to the total, which is 100%. A good example of a pie chart is comparing the January sales to the other months in the Sales 1st Qtr workbook.
The next exercise shows you how to create a pie chart on a separate sheet using the Chart Wizard. The pie chart will show the relationship between the total sales amounts for each month on the Summary sheet in the Sales 1st Qtr workbook.
Select cells B3:D3 on the Summary sheet of the Sales 1st Qtr workbook to identify the month names you want to chart. Hold down Ctrl and select cells B9:D9 to identify the range ...