Chart Color Defaults

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 25 Sep 2006 14:55 GMT

I'm not a big fan of Excel's default chart colors. I can change them as
needed & experiment w/ what looks best, but are there any downloads that
would allow me to conveniently reset the colors in one fell swoop? Thanks.

Signature

Jay

Reply to this Message

Stopher - 26 Sep 2006 07:11 GMT

> I'm not a big fan of Excel's default chart colors. I can change them as
> needed & experiment w/ what looks best, but are there any downloads that
> would allow me to conveniently reset the colors in one fell swoop? Thanks.
> --
> Jay

Why not just create a macro that you could run that sets the default
colours?

Sub Reset_Chart_Colours()

ActiveChart.......

End Sub

It all depends on what type of graph it is but xlAutomatic may work for
you as a parameter for colours.

Stopher

Reply to this Message

Jim Cone - 27 Sep 2006 17:51 GMT

I've just cobbled a workbook together that provides some workbook
color options. It changes the entire color palette so as to display
color variations for Red, Blue, Green, Yellow and Gray/Black.
Each palette displays near white for colorindex 1 to
a dark shade of the specified color at colorindex 56.
Choose color from a dropdown box.

If anyone is interested, email me and I will forward it.
Remove xxx from my email address... jim.coneXXX@rcn.comXXX
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Jay" <Jay@discussions.microsoft.com>
wrote in message
I'm not a big fan of Excel's default chart colors. I can change them as
needed & experiment w/ what looks best, but are there any downloads that
would allow me to conveniently reset the colors in one fell swoop? Thanks.

Signature

Jay

Reply to this Message

Jim Cone - 28 Sep 2006 04:27 GMT

Ask for the "Color Options" workbook.
--
Jim Cone

"Jim Cone" <jim.coneXXX@rcn.comXXX>
wrote in message
I've just cobbled a workbook together that provides some workbook
color options. It changes the entire color palette so as to display
color variations for Red, Blue, Green, Yellow and Gray/Black.
Each palette displays near white for colorindex 1 to
a dark shade of the specified color at colorindex 56.
Choose color from a dropdown box.

If anyone is interested, email me and I will forward it.
Remove xxx from my email address... jim.coneXXX@rcn.comXXX
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Jay" <Jay@discussions.microsoft.com>
wrote in message
I'm not a big fan of Excel's default chart colors. I can change them as
needed & experiment w/ what looks best, but are there any downloads that
would allow me to conveniently reset the colors in one fell swoop? Thanks.

Signature

Jay

Reply to this Message