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
 7.7K All Categories
 3 Connect
 919 Connectors
 244 Workbench
 477 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 38 Visualize
 198 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 27 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 14 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部