Create a Bar + line combo chart with 2 y-axis variables

newbee

02.11.2022_10.44.46_REC.png

Goal is to create something like attached with 2 variables on y-axis. The bars would represent sales dollars and the line would represent payment rate. Series would be store location. Scrolled through other posts on the site and found that they only worked for 1 y-axis variable. Greatly appreciate your help!

GrantSmith

You can utilize a Line + Group Bar chart to replicate something like this. In the general settings you'll defined the number of series which make up the lines on your chart and the rest default to bars.