Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart axes color index vs font color index
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart axes color index vs font color index
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart axes color index vs font color index
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart axes color index vs font color index
I shouldn't have mixed up Automatic with Default. By default the plot area
has an interior color index of 15 and border color index of 16. As far as I know you cannot change the default colorindex values, but you can change the colors corresponding to color indices 15 and 16. For several other chart elements (legend, chart area) fill and border both have color index of -4105, as Andy pointed out. Series also use this default value for marker foreground and background color indices. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, The items that are remaining black probably have a colorindex of -4105 which is the xlColorIndexAutomatic. You would have to set the colour of the chart elements to Black, or colorindex 1. Not sure how or if you can change the automatic colours. Cheers Andy wrote: 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 groups.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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination chart - Line - Column on 2 Axes | Charts and Charting in Excel | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Adding series, this time with a 2 axes line chart | Charts and Charting in Excel | |||
Org Chart Item Automatic Font | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel |