Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to get the Interior property of the PlotArea class | Charts and Charting in Excel | |||
Cell interior color | Excel Discussion (Misc queries) | |||
Interior Cell color | Excel Programming | |||
oRange.Interior.Color | Excel Programming |