Setting colors of individual bars and pie slices

[David H.]

Is it possible to set specific colors for each bar of a bar chart and slice
in a pie chart using OWC10?

I'm currently using myChart.SeriesCollection(0).Line.Color=x to set the
color for ALL bars in a series, but now I need to control the color of EACH
bar, and the same thing goes for pie charts. Any help on how to do this
would be most appreciated!!

Thanks!

 

[David H.]

I found the setting .. there is also an interior.color propery on the point
item in the points collection:

set s1pts = thischart.Charts(0).SeriesCollection(0).points
for each D in s1pts
' retrieve label/legend for each point
pLegend = d.getValue(c.chDimCategories, False)
pValue = d.getValue(c.chDimValues, False)
' <<Add your own logic for picking the right color here>>
D.interior.Color = mycolor
next