Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    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?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts