Dynamic Pie Chart With Fixed Colors

Hello all,


I'm working with a pie chart that has a dynamic range as its data source and a dynamic range as its legend. The chart shows ratios of bought items depending on customer type. So, when you switch from a "Hair" customer to a "Bath & Body" customer, the ratios shift and the legend changes as well (i.e. "Hair - 25%" to "Hair - 10%").


Is there a way to fix the colors permanently so that as the ranges change, the colors remains the same for each category?


I've seen some VBA for it, but it was for data in long columns, whereas my data is in one range in the middle of the worksheet.


I can attach the file if it makes things easier.


Thank you!

Solved it missen.

For those interested,

http://peltiertech.com/WordPress/vba...ategory-label/

is very useful. I was using formulas instead of values for the formatted cells, and that was my trouble.