LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to get the Interior property of the PlotArea class [email protected] Charts and Charting in Excel 2 September 3rd 08 03:41 PM
Cell interior color JohnB Excel Discussion (Misc queries) 4 October 12th 06 06:07 PM
Interior Cell color Pellechi Excel Programming 1 September 23rd 03 03:39 PM
oRange.Interior.Color Vasant Nanavati[_2_] Excel Programming 3 July 13th 03 08:28 AM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"