Microsoft Office Tutorials and References
In Depth Information
Working with the Plot Area
Figure 4-9: The Plot Area for this chart uses a
To reposition the Plot Area, select the Plot Area and then drag a border to move
it. To change the size of the Plot Area, drag on one of the corner “handles.” If you
like, you can expand the Plot Area so that it fills the entire Chart Area. The Plot
Area of the chart in Figure 4-10 occupies the entire Chart Area. The title and legend
have been moved from their default locations and placed over the Plot Area.
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 choose Edit Copy. Click your new chart
and choose Edit Paste Special. In the Paste Special dialog box, select
Formats. This procedure has an odd side effect: It overwrites the chart title
with the title from the copied chart. This is almost never what you want!
Copy the chart; change the data sources. Press Ctrl while you click the
original chart and drag. This will create an exact copy of your chart. Then use the
Chart Source Data dialog box to specify the data for the new chart.
Create a user-defined chart type. Select your chart and then choose
Chart Chart Type. Click the Custom Types tab and select the User-defined
option. Click the Add button and then provide a name and description. When
you create your next chart, use this custom chart type.