Microsoft Office Tutorials and References
In Depth Information
Formatting Chart Background Elements
Figure 7-8: The plot area for this chart uses a graphic image.
To reposition the plot area within the chart area, select the plot area and then drag a border to move
it. To change the size of the plot area, drag one of the corner “handles.” If you like, you can expand
the plot area so that it fills the entire chart area.
You’ll find that different chart types vary in how they respond to changes in the plot area
dimensions. For example, you cannot change the relative dimensions of the plot area of a pie chart or a
radar chart (it’s always square). But with other chart types, you can change the aspect ratio of the plot
area by changing either the height or the width.
Copying chart formatting
You created a killer chart and spent hours customizing it. Now you need to create another one just
like it. What are your options? You have several choices:
Copy the formatting. Create a standard chart with the default formatting. Then select your
original chart and press Ctrl+C. Click your new chart and choose Home➜Clipboard➜
Paste➜Paste Special. In the Paste Special dialog box, select Formats.
Copy the chart; change the data sources. Select the original chart and press Ctrl+C. Then,
activate any cell and press Ctrl+V. This creates an exact copy of your chart. Activate a series in
the new chart and drag the range highlights to the new ranges (and repeat for each series).
Or, you can choose Chart Tools➜Design➜Data➜Select Data to display the Select Data Source
Create a chart template. Select your chart and then choose Chart Tools➜Design➜Type➜
Save as Template. In the Save Chart Template dialog box, provide a descriptive filename.
When you create your next chart, choose Insert➜Charts➜Other Charts➜All Chart Types, and
select the Templates tab. Then, specify the template you created.