Thread: Line Column Chart-how to adjust

I have a chart, which illustrates scores for business by quarter. I want the quarterly numbers to be shown in a bar,(4 bars) and the average variance to be shown as a line across the graph, with a second y axis. When I choose that chart type, the default gives me 3 bars, 2 lines, completely throwing off the chart. Any advice???

I am attaching a sample of the chart. Everything needs to stay as it is, but I need a scatter line which will illustrate the variance, and a scale from 1-20 on the right side. (The variance would be 100-score).