Change default colors for charting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Smith - 21 May 2008 23:42 GMT

I would like to change the default colors fot the lines and background in
Excel charts. The default background is gray and wastes toner and the yellow
default color for series 2 data is difficult to see on a white backgound.
Anyone know where these are stored or how to change these settings?

I know how to change the colors, but don't want to have to do this every
time I chart.

Thanks

Reply to this Message

Andy Pope - 22 May 2008 09:20 GMT

Hi,

Jon has information on creating custom types. You can also update the
Default chart type.
http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I would like to change the default colors fot the lines and background in
> Excel charts. The default background is gray and wastes toner and the
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Peter T - 22 May 2008 21:54 GMT

Another way is to customise the palette. Look at Tools / Options / Color.

As you mention yellow I guess you typically create line type charts, yellow
is 'automatically' applied to the third line type series. Or rather, the
colour in the 3rd column of the 7th row is applied, which in a default
palette is yellow. Customize that yellow (not the identical yellow in the
4th row) and any others in the bottom row of the palette. Also customize the
light grey in the 8th column of the 4th row in the palette.

A customized palette is stored with the workbook. You could save a template
with your customized palette. Either use the template as is or use it to
copy a palette into your new workbook (same dialog as mentioned above).

Regards,
Peter T

> I would like to change the default colors fot the lines and background in
> Excel charts. The default background is gray and wastes toner and the yellow
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message