Add, change, or remove a field

1. On the chart toolbar, click Field List .

2. Use the scroll bars and the expand indicators ( and boxes) to find the field you want to add to the chart.

3. Click the field and drag it to the appropriate drop area on the chart.

   You can add multiple fields to each location.

   Notes

   • As an alternative to dragging the field, in the field list, select the area to which you want to add a field (areas are listed at the bottom of the field list), and then click Add to. If Add to becomes unavailable when you select the area where you want to put the field, the field you selected might not be available for use as a category, series, data, or filter field.

   • If your chart is based on source data from an OLAP database, only the fields that are not listed under Totals in the field list can be used as category, series, or filter fields.

   • You can add more than one field to an area on the chart. The placement of fields on the chart determines the hierarchical order in which the data is displayed. Outer fields can be expanded or collapsed to show more or less information in inner fields.

1. Click the data field that contains the values you want to summarize.

2. On the chart toolbar, click AutoCalc , and then click the summary function you want.

Note  The AutoCalc button is unavailable when the source data for the chart does not allow you to add total fields— for example, when the source data is from an OLAP database.

When you remove a field from a chart, data from the field is no longer displayed, but the field remains available in the field list for viewing.

1. Click the field label of the field that you want to remove from the chart.

2. Drag the field toward the outside of the chart until the pointer changes to .