LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default PlotArea.Interior.Color ... all white

Markus,

If you have a default palette Tom is most certainly right.
Your very pale lilac will be mapped to the nearest colour
which is white (colorindex 2). Instead try:

Activeworkbook.colors(15) = RGB(238, 241, 252)

Colorindex(15) is applied to the Plot area by default (not
same as "automatic"), light grey in an uncustomized
palette. Plot areas in new charts, as well as those to
which you have not applied another colour, will adopt your
customized colour. Of course you could customize any
other palette colour and apply that instead.

Cell and Chart colour formats can only accept palette or
automatic colours (system black & white).

The "Chart fill" colours Tom referred to are applied both
by default and as automatic colours to series that can be
filled. Linked to series / color index orders starting at
1 & 17 respectively, and not limited to 8.

Regards,
Peter T

-----Original Message-----
Just a guess. Colors are restricted to the 56 colors

defined in the
palatte. If you assign an RGB color, it is mapped to the

nearest color in
the palatte. If you go to Tools=Options, color tab, you

see there are only
8 colors listed for chart fill. Perhaps your color is

being mapped to white
as the closest.

--
Regards,
Tom Ogilvy

Markus Grein wrote in message
-

online.net...
by the way ... that's Excel 2k under Win2k ...


"Markus Grein" wrote in message
-

online.net...
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) <<

....





.

 
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 03:34 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"