Setting a section to No Fill

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lynxbci3 - 12 Oct 2005 13:43 GMT

Hi,

I have a program that automatically sets the segments in a pie chart t
the correct colour (set using RGB(c1,c2,c3)) see code below

Charts("EPE Wheel").SeriesCollection(1).Points(pnt).Interior.Color
RGB(c1, c2, c3)

However there is occasioanlly a black segment and i would like to se
it to No fill instead of black. I can do all the If...then but what i
the code to set a section to no fill?

many thank

Reply to this Message

Ed Ferrero - 12 Oct 2005 22:29 GMT

Hi Lynxbci3,

Charts("EPE Wheel").SeriesCollection(1).Points(2).Interior.ColorIndex =
xlNone

Ed Ferrero
http://edferrero.m6.net/

> Hi,
>
[quoted text clipped - 9 lines]
>
> many thanks

Reply to this Message

Jon Peltier - 17 Oct 2005 04:29 GMT

Hint:

I bet Ed used the macro recorder to figure out the syntax. It's a very
handy tool.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

> Hi Lynxbci3,
>
[quoted text clipped - 17 lines]
>>
>>many thanks

Reply to this Message