Setting a section to No Fill

L

Lynxbci3

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
 
J

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a pie chart segment to No Fill 1
Excel VBA 1
Changing ChartTypes will not change the color of the Series 2
Extract RGB values for selected chart series 2
No Chart Titles 1
Pie Chart Not Working 1
Custom colours in charts 3
Setting a cell's color based upon RGB values 6

Top