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

newbee
newbee
in Charting
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!

Answers

  • GrantSmith
    GrantSmith Coach

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • newbee
    newbee

    Hey this the line and bar designation would not depend on the series. The variables would. The payment rate variable (on the y-axis) would go to line and sales dollar variable (a separate y-axis variable would go to bars.)

    My data table below and my desired output using Excel. Need help replicating that in DOMO

    02.11.2022_11.03.12_REC.png


Categories