The toolbar at the top of the chart provides a set of commands for working with the chart display and chart data. For example, you can use the toolbar to add or remove a legend, and in some cases to change series or category data to reflect data in rows or columns. The toolbar is most useful when your chart is based on data from a PivotTable list or database table or query, and you want to sort, filter, or change the display of data in a chart.
To see the command name of each button, rest the pointer on the button.
The Commands and Options dialog box
The Commands and Options dialog box, which includes advanced commands for working with charts, is not available during run time by default. Help for the Commands and Options dialog box is also not available from within the chart at run time. For more information, contact the designer of the Web page or your system administrator.
The field list is available from the chart toolbar when the chart is based on database data or on a PivotTable list. Use the field list to view the list of fields that are available from the source data and to add fields to the category, series, filter, and data areas of a chart. In the field list, the fields that are not bold are available but not yet displayed in the chart. The bold fields are already displayed in the chart. You can scroll and click the expand indicators ( or boxes) to show or hide additional fields.
When you right-click an active chart, the shortcut menu displays commands to show or hide the toolbar, commands to show or hide the field list and drop areas, and other options.