« Basic Functions: ISERR | Main | Macros: Getting Cell Information »

November 22, 2004

Charting: Pie charts

A step by step - and hopefully easy-to-follow - guide to creating a basic pie chart.

The table below is a good candidate for generating a pie-chart.

chart2_1.jpg


As before, we select Insert - Chart and the first Autoformat Chart dialog box appears. If you have not already selected the table, you can manually enter the range at this point.

chart2_2.jpg


Once we select the pie-chart option, we get a small preview of the finished chart in the dialog box.

chart2_3.jpg


For pie-charts, there are four variants for us to choose from.

chart2_4.jpg


The next dialog window allows us to add a title to the pie-chart.

chart2_5.jpg


Our first pie-chart! It still needs cleaning up - but this will be covered in a later tip.

chart2_6.jpg

Posted by Dave at November 22, 2004 04:43 AM

Comments

Post a comment




Remember Me?