Autofill chart columns based on label text

I have a dashboard that I generate multiple times a day based on different datasets.

Each time I am manually changing the fill colour of each column to make it easier to visualise what each column represents/belongs to.

Attached is a desensitised document with an example of what I am trying to achieve, without having to manually change the fill each time a chart/report is generated.

Thanks in advance!

HI
Try this macro to associate with a button
HI,
Mario

Please Login or Register  to view this content.

Thanks Mario,

That is extremely useful!

I forgot to add to my comments, is it possible to have multiple charts and criteria within one sheet update on one single macro as well?

Cheers

HI
It is always better to insert macros in a standard Module and not in the Sheet Module.
Try with the new macro that I associated with the button.
Keep in mind that it "holds" for 2 charts.
This is the code:

Please Login or Register  to view this content.

HI,
Mario

Came across another challenge,

When values are 0, the relevant rows are hidden in my tables so that they do not show up as 0 on the charts and instead, are ignored and not displayed.

Do we know any amendments that can be used in the module to say: 'if the row is hidden, don't try to find what colour the chart object should be and just skip onto the next'.?

I hope this makes sense as I am speaking in layman's terms as opposed to VBA.

Thanks in advance!