Excel pie chart - fix pie colour by category name

Hey guys,

Another question here regarding the pie charts in excel.

I'm building a list of charts with 18 categories in one pie each. The category names are the same however the value/piece of pie size varies. Now when I select the data for each new chart, the color reassigns so there is absolutely no consistency.

Is there a way I can lock the color by name like category name, John/Jane/Brian and then list of values? This way I can easily show whose value has changed. Now all the colours are not consistent (Jane has 18 different colours in 18 different charts since the orders/values have changed).

Thanks!

Originally Posted by dflak

In "cleaning up" the code, I accidentally deleted a declaration of a variable so the previous version yields an error.

Hey dfalk,

Thanks so so much for your input!

I will run the macro sometime this week and see if I can embed it into my spreadsheet this weekend.

I will keep it updated and let you know how I go.

Thanks again!

Frankximus

Originally Posted by dflak

In "cleaning up" the code, I accidentally deleted a declaration of a variable so the previous version yields an error.

Hey dfalk,

Your codes are absolutely amazing!

Thanks heaps!

Hi,

Unfortunately, if you sort the "values" to Largest to smallest, the colours for each person changes

Regards

peterrc

You'll need to sort the entire tables contents if you want the data to "remain" with each name. Highlight the entire table and resort by name, descending order and my charts don't change their colors with respect to the name.

However, when I attempt to copy the macro over to my worksheet I get this:

For Each cl In Range("Table_Charts[Charts]")

as an error message from Excel.

Any assistance would be appreciated.

Hi, I'm new here and didn't want to open a new thread for the same issue. Sadly the sample excel sheet doesn't work with Office 2016
Before asking too many questions, I wanted to try it by myself using that sheet. Is it corrupted or is it just Office 2016?