Microsoft Office Tutorials and References
In Depth Information
Customizing the appearance of charts
You can also display a similar set of formatting controls for a chart element by clicking the
Chart Elements action button, pointing to the name of the element you want to change,
clicking the right-pointing triangle that appears, and then clicking More Options. Doing so
displays the pane related to that element.
With the third action button, Chart Filters, you can focus on specific data in your chart.
Clicking the Chart Filters action button displays a filter interface that is very similar to that
used to limit the data displayed in an Excel table.
Selecting or clearing a check box displays or hides data related to a specific value within a
series, which you can select as well.
If you think you want to apply the same set of changes to charts you’ll create in the future,
you can save your chart as a chart template. When you select the data that you want to
summarize visually and apply the chart template, you’ll create consistently formatted charts
in a minimum of steps. To save a chart as a chart template, right-click the chart and then
click Save As Template. Use the controls in the dialog box that opens to name and save your
template. Then, to create a chart based on that template, select the data that you want to
summarize and on the Insert tab, in the Charts group, click the dialog box launcher in the
lower-right corner of the group to open the Insert Chart dialog box. On the All Charts tab,
click Templates, click the template you want to use, and then click OK.