Split axis in bar/combo chart

[#1]

Hi, I have a normal bar chart with 2 expressions and I want to create a line chart representing the percentage difference between those 2 expressions. However, the percentage is very small and it will just seem like a straight line on the x-axis. So I want to bring the line chart axis on top of the bar chart axis so that the line chart is clearer to see. All this is still in one object/chart area. How can I do this? Thanks.

[#2]

you can make 2 charts and make them sit on each other.... and then use the 'Layer' option in the 'Layout' tab of the chart to control which is at the front and which is at the bottom.

[Anonymous · Accepted solution]

Why not you use the second axes for the difference one

For Expression 1 and Expression 2 use Left(Bottom) and

Expression 3 use Right(Top).

You can find it in Axes tab, under Position.

Regards

Nitin

[#4]

Thank you!