View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markus Grein Markus Grein is offline
external usenet poster
 
Posts: 6
Default PlotArea.Interior.Color ... all white

Hello everyone ! :)

Maybe someone can help me with a problem :

I am trying to assign a custom color to the plot area of an Excel chart
programmatically. So, I define a long variable (cCol51&) and assign the RGB
values as usual :

cCol51 = RGB(238, 241, 252) <<


I kept the variable on the watch list during debugging, and it shows a value
of 16577006 - so far, so good.
Then, I want to assign that color (light shade of violet) to the PlotArea
background of a chart, like this :

ActiveChart.PlotArea.Interior.Color = cCol51 <<


And what does it ? Nuthin ... it makes it all *white* ... have checked with
my oculist, but there's nothing wrong with my color sensation ...
Doing the same to a certain range of cells, however, *does* the job alright
(??).

I *used* to assign the color via a modified ColorIndex of 51 - that went
well, but I thought it might be better not mess around with the user's color
schemes.`
On the other side, setting the variable to RGB(255,0,0) works fine!

Any idea why the RGB / long variable method does not work with the custom
color I'd want to use here ?
Are there limitations to the color settings of a PlotArea as opposed to a
cell ?

Thanks a lot in advance !!

cheers,
Markus