An alternative to populating Pie Charts by dragging and dropping values is to populate a pie chart from an existing Spreadsheet.

 

If a Spreadsheet exists on the layout, an inserted Pie Chart will be automatically populated with the data from Columns A and Column B within the Pie. Column A will be the series name and column B the value used in the Pie Chart.  If more than one spreadsheet exists, select that which is intended as the data source prior to inserting the Pie Chart.

 

By default, the first two columns of the Custom Data Grid for the Name- and Value-parameters of each sector (slice) will be plotted on the Pie Chart, respectively.  

 

To populate the Pie Chart with parameters other than these first two columns of the Custom Data Grid,

 

1.Select the Format tab→Plot Options→Overlays command (Figure 5.220)

 

 

2.Choose the Spreadsheet column intended for the value of the sector (slice), from the Value Parameter drop-down menu.

3.Choose the Spreadsheet column intended for the name of the sector (slice), from the Name Parameter drop-down menu.

 

See Formatting Pie Charts for details on how to customize colors, legends, rings, and more.