Keep Same Colour with product

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pie chart which is based on the sales of my top 5 products each
quarter.
If I have a total of 20 products, I want to assign a different colour to
each product. This colour remains the same for this product always whether it
appears in my top 5 list or not.
How do I get my pie chart segments to always be the same correct colour each
quarter ?
 
Hi,

You may have to resort to VBA for this.

Some code like this where the i variable is the appropriate colorindex
value for the slice.

for i=1 to 5
activechart.SeriesCollection(1). _
points(i).interior.colorindex = i
next i

Cheers
Andy
 
Thanks for that, worked a treat !

Andy Pope said:
Hi,

You may have to resort to VBA for this.

Some code like this where the i variable is the appropriate colorindex
value for the slice.

for i=1 to 5
activechart.SeriesCollection(1). _
points(i).interior.colorindex = i
next i

Cheers
Andy
Click to expand...
 
Back
Top