Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
Chart Area Default Color
Posted by William Lund on February 07, 2002 12:28 PM
Every time I create a chart the plot area is dark gray. Is there some way to have the default property of a chart to have the plot area background be white or some other color? I have to change it every time. Some days I create quite a few. I guess I could create a custom chart with the properties, but Excel must have a way to do this for the built in charts.
Other people I work with also run into this problem.
Re: Chart Area Default Color
Posted by faster on February 07, 2002 2:42 PM
Create the chart you want to use as a default.
Right click the chart and select Chart Type.
Select the Custom Types tab.
Click Set As Default Chart (bottom of window).
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.