Line and bar combinations help

edited November 2022 in Charting


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


Best Answer

  • 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.