How to fix graph color by category name

[willow1985]

My skills with graphs are not very strong and I am currently facing a problem with a couple of graphs that my employer requires to be colored.

The problem is I need the categories to stay the same color no matter how the data changes

For example if Quote Hold - 94 value changes to 53 "Quote Hold" now becomes green instead of grey. I need the catagories to stay the same color that is assigned. Is there a way to do this, rather with graph settings or VBA?

My data is currently in a table called [Open_WorkOrders] and a Macro automatically resorts it as well.

Open_WorkOrders Table:

Any help would be greatly appreciated.

Thank you!!

Carla

 

[Norie]

Carla

Are you currently creating the chart(s) with VBA?

 

[willow1985]

I am using a macro to populate another sheet with data in which the table reads. I also use VBA to refresh the table sorting only from Largest to Smallest for column Y