Thanks for your reply, Jon. I'm still not clear, though - I thought
that Excel had a 56 color map, and when I look at the map under the
Tools...option tab, only one of those colors is black. So if all the
elements are black, how can they have different color indexes? I
understand that they can all be set independently, but if all the
elements are black then must they not all have the same color index?
Either that or they use separate color maps, in which case, how can I
see and edit the various colormaps used in Excel?

Thanks for your help, and incidentally I've learned a great deal from
your Website examples, they are very well done.

D
Jon Peltier wrote:
Each element has a default (automatic) colorindex which is independent from
all the others.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
Hi All

quick question here regarding color indexes. Our company approved
Powerpoint style has a dark background, so when we paste Excel charts
we need to change all the black elements to white. I thought it would
be faster to just change black to white in the "tools .. options..
colors" tab. When I do that, all the lines on our charts turn white but
everything else (axes, legend, title) stays black, even though the
color for all elements is set to automatic. So, do these elements use a
different color table, or does automatic not assign the same color to
all the elements, or what? I have written a VBA macro to individually
change the elements, but it's not so elegant, and I'd like to
understand why my first attempt didn't work.

Thanks for any help!

D