Hello all,

I was wondering if it is possible to loop through data points in a chart and change their color based upon a corresponding cell. For example: all my charted data is in column C but it is separated into categories (juice, pop, candy, fruit) in column A... What I'd like to do is, if the number corresponds to juice, for the point to be yellow, if it corresponds to pop to be green, candy = orange, fruit = blue. I found a macro to change the color of data points to the color of the source cell but, it only works for individual charts for each of the categories... I'd like it to work for one chart containing all the categories. I've pasted the macro below, please let me know if you have any questions.

thanks.
**MySeries is used in place of myPoint for individual chart coloring
Please Login or Register  to view this content.