Pie Chart: How to make pie charts in Excel 2007?

Filed Under: Excel Tips, Office 2007

Pie Chart is a graphical representation of the relative sizes of the shares of a whole. It is a good method of representation, if you wish to compare a part of a group with the whole group. Pie charts don’t give very detailed information, but they do give a quick overall impression of the results.This article is on creating pie charts in Excel 2007.

Excel 2007 has enhanced charting capabilities than the earlier versions.It provides a variety of charting tools to customize the design, layout, and formatting of the chart. You can see a preview of how the various options would look by just pointing at them in the dialog box. And when your chart is exactly the way you want it, you can save it as a template to use again, in Excel or in other 2007 Office system programs such as Word 2007!

How to make Pie Chart in Excel 2007?

Creating impressive looking pie charts is way too easy in Excel 2007. To create a Pie chart in Excel, you should first enter the numeric data for the chart on a worksheet. Then you can plot that data into a Pie Chart as detailed below:

  • Select the data that you want to plot in the pie chart.
  • On the Insert tab, in the Charts group, click Pie.
  • Choose either a 2D chart type or a 3D Pie Chart, say, Pie in 3-D
Pie Chart
  • Click the Plot area.In a 2-D chart, the Plot area is the area bounded by the axes, including all data series and in a 3-D chart, it is the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
Pie Charts in Excel
  • On the Design tab, in the Chart Layouts group, select the Chart layout that you want to use, say, layout 2.
  • If your chart has too many legend entries or if the legend entries are not easy to distinguish, you may want to add data labels to the slices of the pie chart instead of displaying a legend (Layout tab, Labels group, Data Labels button).
  • On the Format tab, in the Shape Styles group, click Shape Effects, and then click shape effect you desire, say, Bevel.
  • Click 3-D Options, and then under Bevel, click the Top and Bottom bevel options that you want to use.
  • In the Width and Height boxes for Top and Bottom bevel options, type the point size that you want.
  • Under Surface, click Material, and then click the material option that you want to use.
  • Click Close.
  • On the Format tab, in the Shape Styles group, click Shape Effects, and then click Shadow.
  • Under Outer, Inner, or Perspective, click the shadow option that you want to use.
  • To rotate the chart for a better perspective, select the plot area, and then on the Format tab in the Current Selection group, click Format Selection.
  • Under Angle of first slice, drag the slider to the degree of rotation that you want, or type a value between 0 (zero) and 360 to specify the angle at which you want the first slice to appear, and then click Close.
  • Click the chart area of the chart.
  • On the Format tab, in the Shape Styles group, click Shape Effects, and then click Bevel. Under Bevel, select the bevel option that you want to use.
  • If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:
    • On the Page Layout tab, in the Themes group, click Themes.
    • Under Built-in, click the theme that you want to use.

That is all folks! Isn’t it easy to make pie charts in Excel 2007?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Recommended Videos

Excel 2007-Pie Chart
Excel 2007-Pie Chart
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
How to make a pie chart using Excel 2007.avi
How to make a pie chart using Excel 2007.avi
Excel 2010 Tutorial For Beginners #11 - Charts Pt.2 Pie Chart (Microsoft Excel)
Excel 2010 Tutorial For Beginners #11 - Charts Pt.2 Pie Chart (Microsoft Excel)
How to create a pie chart in Excel 2007
How to create a pie chart in Excel 2007