Line and bar combinations help

Jones01
Jones01 🟡
edited November 7 in Charting

Hi,


I am trying to create a chart by weeks showing

Sales as a bar

Budget as a bar

and then the variance between the 2 as a line.


I want the scale for the variance to be on the right hand side and the scale for sales and budget on the left.


I am trying lots of combinations but can't seem to find the one that fits.

Would anyone be able to point me in the right direction please?


The best I can do is as above but the variance scale ends up on the left. Can you swap these?

Like this



Thanks

Best Answer

  • Jones01
    Jones01 🟡
    Answer ✓

    I'll mark this as resolved and answer my own question as hopefully will be useful for others.


    To get this behaviour I choose a Grouped bar + line chart.

    My sales went on the Y axis value and then next part was important.

    The next series value was budget followed by %.

    Then to move the budget value onto the left scale I selected the following which I assume tells the chart I want sales and budget on the left scale which leaves % on the right.