|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
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?
Thanks
Jack
> Is there a reason why this happens?
Because it’s programmed that way 
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.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
