Line and clustered column chart - dynamic color change for column when there are two columns

[Anonymous]

Hi, I know there is currently a workaround dynamic colouring for the bar chart when we use line and clustered column chart. However, I need to show two bar graphs and dynamic colouring by using 'column series' doesn't work in this situation.

Any proposed solutions?

Alan

[v-juanli-msft]

Hi @Anonymous

Could you show an example of your data and the screenshot of your result currently?

 I make a test as below, is this what you what?

Best Regards

Maggie

[Anonymous]

Hi Maggie, thanks for your reply.

See below for the graph (using dummy data) I'm trying to format.

So, for the blue bar, what I want is blue when Scenario is Actual and grey when Scenario is Forecast. I already have the calculations for Actual vs Forecast set up. So from Jul to Nov, the blue bar shows actual values and from Dec to Jun, the blue bar shows forecast values. What I'm trying to do now is to change the colour formatting where actual values are blue and forecast values are grey. I still need to keep the Bus_Forecast bar as well as the color formatting.

Any help is much appreciated

[v-juanli-msft]

Hi @Anonymous

It seems your dummy data like this

If so, it doesn't support to change colors as you expected.

it could only change the color like the following

Best Regards

Maggie

[Anonymous]

Hi Maggie, thanks for your reply. I tried your solution already and it does work, but I have been asked to include the second bar series, CFO forecast and that is where I am stuck. I can't get the second bar series and get the bar graph colouring to work. Do you think there is any way to do it?