Changing default chart background color

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

How do I change the default chart background color? I
don't like the grey and I always change if to white. I
have to do it manually every time. Is there a way to
change the default?
 
You could create a user-defined Custom Chart Type, and make it the
default chart, or you can record a macro that formats the completed
chart exactly the way you'd like it.

To create a custom chart type:

1. Select a chart that's formatted the way you'd like other charts
to look. Note that any Titles in the chart will be included in
the format (including the Title text).
2. From the Chart menu, choose Chart Type
3. Click on the tab - Custom Types.
4. At the bottom left, select User Defined.
5. Click the Add button.
6. Type a name for your new chart style, and (optional) a description.
7. Click OK
8. To make this the default chart type, click the Set as default chart
button, click Yes to confirm the change when prompted.
9. Click OK.

To create a chart based on a your new style:
If you made the chart the default style, you can select the data and
labels, then press the F11 key to create a new chart in that style.
OR
1. Select the data and labels for the chart.
2. Click the Chart Wizard button on the toolbar.
3. Click the Custom Types tab, and select User Defined.
4. Select your chart type, then click Next.
5. Continue through the wizard, then click Finish.
 
Back
Top