O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Pie Chart

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.

To Do: Create a Pie Chart

1.
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required