Microsoft Office Tutorials and References
In Depth Information
Customizing the appearance of charts
TIP You can apply a template to an existing chart by selecting the chart and then, on the
Design tab, in the Type group, clicking Change Chart Type to open the Change Chart Type
dialog box. Click Templates, click the template you want to use, and then click OK.
In this exercise, you’ll change a chart’s layout, apply a new Chart Style, change the number
format of the values on the vertical axis, save the chart as a chart template, and apply the
template to another chart.
SET UP You need the VolumeByCenter workbook located in the Chapter09 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
On the Presentation worksheet, select the chart.
On the Design tab, in the Chart Layouts group, click Quick Layouts , and then click
the first chart layout Layout 1 .
To the right of the chart, click the Chart Styles action button to display the Chart
Click Style 7 to change the chart’s style.
Click the Chart Styles action button to hide the Chart Styles gallery.
Click the Chart Elements action button, point to the Axes entry, click the
rightpointing triangle that appears, and then click More Options to display the Format
In the pane, click Axis Options , and then click Vertical (Value) Axis .
Click Number to display the Number options in the Format Axis pane.
In the Category list, click Number to display the Number category’s style options.