+ Reply to Thread
Results 1 to 2 of 2

Setting a pie chart segment to No Fill

  1. #1
    Registered User
    Join Date

    Setting a pie chart segment to No Fill


    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.Color = 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

  2. #2
    Dave O

    Re: Setting a pie chart segment to No Fill

    Try this, please:
    Charts("EPE Wheel").SeriesCollection(1).Points(pnt).Interior.Color = 0

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1