Alternate for line and stacked column chart

[Anonymous]

Hello All,

I am trying to change the color of line in line and stacked column chart based on my sales, But I dont see any option to change the color condtionally in this change.

Could any please suggest  chart where I can show sales and Profit in single chart and can change color based on profit values

[v-henryk-mstf]

Hi @Anonymous ,

You can set the color of column and line in the corresponding area of format your visual (for column you can also set the corresponding color according to the conditional format).

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-henryk-mstf ,

I need change the line color conditionally.

Say I am showing profit in line , now I  need to show red when its < 100 and green when its > 100

Is it possible ?