Results 1 to 2 of 2
2006-06-16, 08:33 #1
- Join Date
- Mar 2005
- Kent, England
- Thanked 0 Times in 0 Posts
Custom Excel Color Palette Problem (Excel 2003)
Can anyone help? I have created a default color palette, using the company's standard color scheme (for branding purposes). I have noted that when creating a chart, the background color defaults to Column 8, Row 4 of the color palette. Is there a reason why this happens? Can I manipulate which color to use on palette for the chart background?
2006-06-16, 08:50 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Custom Excel Color Palette Problem (Excel 2003)
> Is there a reason why this happens?
Because it's programmed that way <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
Excel uses specific colors from the palette for specific colors. Chart fill and line colors are indicated explicitly, this one is implicit.
You can select another background color and set the chart as default, but that is a user-level setting, stored in a file named xlusrgal.xls in your profile.
You could create a macro that sets the formatting preferences you like, and make it available through an add-in.