Creating a Pie Chart in Excel

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Pie Charts show the relative size of parts in a whole. Each data series in a pie chart has a unique color (or pattern) and the data will be sorted with largest numbers appearing first. Pie charts have no x-axis or y-axis and have only one data series. Because of this, your data values should be arranged in one column or one row, with an optional column or row of category names.

You can consider using a pie chart when:

• You have only a few numbers to chart (you should not have more than seven categories).
• You have only one data series to plot
• You don’t have any negative or zero values
• Your data series does not include many low numbers (they will be too small to compare)
• You want to show how each value in your series contributes to the whole

Once your pie chart is created, you can then rotate the slices for different perspectives or pull individual slices out of the chart to draw attention to them. Use the Layout, Data Labels or More Data Labels options to specify the labeling of the pie slices.

To Create a Pie Chart

1. Select the data you wish to include in your chart.
2. Click the Insert tab on the Ribbon.
3. Click the Pie button on the Charts group and click the type of pie chart you want to insert.
4. Use the Layout, Data Labels or More Data Labels option to specify the labeling of the pie slices.

Similar Posts:

• To Create a Chart in Excel 2007
• Labeling Chart Elements in Excel 2007
• Customizing Chart Axes in Excel 2007
• How to Set a Default Chart Type in Excel
• Change the Layout and Style of a Chart in Excel 2007
• Creating a PivotTable Form in Access
• Change the Chart Type in Excel 2007

Tagged as: Excel Tips, Microsoft Office Tips