Visualisation in Bar Chart

[mhmmd_srf]

Hi All,

I have one bar chart like below:

User wants to see the deviation b/w Actual and Planned.

Deviation: Actual * 100/Planned.

What would be the best way to show all three in single chart.

Please help.

Thanks,

Sarif

[Anil_Babu_Samineni]

You can do this?

Dev((Sum(Actual) * 100)/Sum(Planned),0)

[mhmmd_srf]

Need to create different Bar?

[Kushal_Chawda]

one option is "Straight table" in which you can show it all three in single chart.

If you want graphical representation, you can go with "Combo chart", in which you can show Actual & Plan as Bar and Deviation as line. You can go to chart properties->Axis tab-> change position of Actual & Plan as left and deviation as right.