Colors in Pie chart

I am plotting a pie chart using MS Office Chart Component 9.0..VB assigns color to the pies automatically.What I have observed is that when number of values are greater than 16 ,it starts assigning the same series of color.ie 1st and the 17th value get the same color code.I dont want this to happen.
PlZ help

I think that there are only 16 colors available.....

If so, then your choice is to
a) find another chart control
b) make your own

If you decide to make your own, look up the ARC API function....


"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder

another alternative would be to group some parts of that chart to make a bigger % but less than 16 items

I'll be amongst the best any minute now !

That reminds me....

I haven't used the pie chart in a while....is it possible to set patterns? If so, you could have different pattern/color combinations....


"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder

Now I have maintained a table in which I have assigned color codes to each Product.(Say "red" to Choclates,"black" to toffees etc)
So while painting the slice of the pie for each product I pick up the color code from the above mentioned table.