Line and bar combinations help
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

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.
0
Categories
 10.7K All Categories
 13 Getting Started in the Community
 41 Beastmode & Analytics
 2.1K Data Platform & Data Science
 59 Domo Everywhere
 2.7K Charting
 2.5K Ideas Exchange
 1.3K Connectors
 362 Workbench
 303 Use Cases & Best Practices
 503 APIs
 120 Apps
 48 News
 753 Onboarding
 1.2K 日本支部
 Private Company Board