Hi,

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

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

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

many thanks


--
Lynxbci3
------------------------------------------------------------------------
Lynxbci3's Profile: http://www.excelforum.com/member.php...o&userid=10377
View this thread: http://www.excelforum.com/showthread...hreadid=475372

Hi Lynxbci3,

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

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


Hi,

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

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

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

many thanks


--
Lynxbci3
------------------------------------------------------------------------
Lynxbci3's Profile:
http://www.excelforum.com/member.php...o&userid=10377
View this thread: http://www.excelforum.com/showthread...hreadid=475372

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/
_______


Ed Ferrero wrote:

Hi Lynxbci3,

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

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


Hi,

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

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

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

many thanks


--
Lynxbci3
------------------------------------------------------------------------
Lynxbci3's Profile:
http://www.excelforum.com/member.php...o&userid=10377
View this thread: http://www.excelforum.com/showthread...hreadid=475372