Changing color in several Graph

Hi Forum,

First message here. Glad to have registered. I live in Dubai at the moment.
I am building a dashboard in Excel that contains hundreds of graphs.

Question:
Is it possible to change the color of a series for multiple graph at the same time.

I don't think so, I've been looking on the web for a solution... that would save lot of my time.
But can't find it out, which is the reason why I'm writing here now.

Cheers
Ben

Originally Posted by noboffinme

Hi Benju,

I don't think this is possible, maybe using VBA.

Why do you need to make this change?

Hi,

Thanks for your reply, I need that cause I have a dashboard that has more than 100 graph, all similar but I need to change color of the series.
I can do that manually, but it might take me 2h.
I doubted it but sometimes excel can be surprising.
Thanks though.