I'm having troubles with changing color for the same dimension in different chart.
I have 2 different charts (2 different worksheet) with the same datasource.
I'd like to change the color for the second chart: blue at the beginning and orange for the second part as it is in the first chart.
The position of dimensions have to be the same like it is on the picture, I only need to switch these 2 colors.
Do you have any idea how to do it? Thank you
You will have to create a duplicate of your dimension and use that one for the second chart so that it's color is independent of the dimension on the first chart.