Pie Charts: Make segments same color as cells in labels column

[doug firr]

I'm sure that there is a way to do this but just cannot figure it out.

I have a number of pie charts and have to individually alter the color of each segment based on the brand.

I tried filling the cell labels used to create the charts with corresponding colors e.g. imagine the list below is a column.

brand 1 (background color is red)
brand 2 (background color is blue)
etc

I had hoped that when generating a pie chart with the label column varying colors that the segments would be colored correspondingly but no such luck. Does anyone know how to do this?

 

[Andy Pope]

There is but it requires code. See Jon Peltier's blog
http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-category-label/

 

[doug firr]

That worked and has saved me much time. Sincere thank you

 

[doug firr]

There is but it requires code. See Jon Peltier's blog
http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-category-label/

Hi again
I have very limited (zero) VBA experience, I just copy pasted the code in your link.

The code works in one workbook but not another, I have no idea why? Do you?

 

[Andy Pope]

Not really, not enough information.

I assume you altered the code to reference the correct cell range.
And that the chart was selected when you run the code from the other workbook.

 

[doug firr]

Hi Andy,

Just figured it out. I had some hidden columns and needed to change the column ref to H and not A. Thanks again