Creating a Pie Graph

Use graphs to analyze financial trends in a corporation visually. Accounts linked directly from the accounting database in Working Papers or Time easily transform into a graphical presentation.

In a pie graph, each cell value is a data point, which displays as a pie slice. A unique color and label is assigned to each slice. A data series refers to a group of data points. It is only possible to plot one data series in a pie graph. Set prominent data points apart from other pie slices and group minor data points into one slice by using the Slice Exploding and Grouping features. Alternately, specifying the data points to plot can exclude data points entirely.

Any negative data points display as zero in a pie graph. Click the Preview tab to view the graph as it appears in your document.

Place the cursor where you want to insert the graph. On the Insert tab, click Graph. Select Pie and click OK.
Click the Labels tab. In quotes, enter the Title and sub-title (if any) for the graph.
Click the Fonts tab. Select fonts and formatting for the titles.
Click the Data tab.
In the Cells Available list, select a cell for your graph. Click the applicable square in the Data Series table you wish to add the cell to, and then click the right arrow key to link the cell. Alternatively, you can drag and drop a cell to a square in the Data Series table.

Select multiple cells, using Shift + click or Ctrl+ click, to populate the same vertical number of squares in the Data Series table.

Note: Though you can add more than one data series to a pie chart, only one data series can be displayed at any one time.
Click the Pie Options - Format tab. Set any formatting you want for the pie chart. If applicable, select a Graph Width and Height.

Tip: To group data points less than the percentage specified on a pie slice labeled Other, select a percentage from the Slice Grouping option.
Click the Pie Options - Data tab. In the Data Series list, select the data series to use for the Pie chart (if there is more than one in the Data tab).
In the Representation list, select the appearance of numeric values on the pie (percentage or numeric values).
Under Slice Customization, select the Select Slices to Explode option to emphasize selected data points or select the Select Data Points to Pie option to plot selected points from the data series.
Make any modifications to the appearance of the chart and then click OK.