Chart on Report with 2nd data

(Not sure if this is the right place to post this question)

We created a report with a bar chart and we are plotting a 2nd piece of data that is displaying across the bar chart as a thin blue line.

The bar chart shows monthly sales and the blue line shows monthly quotas.

So visually you (in theory) you should be able to quickly see if the monthly sales are above or below the monthly quota.

The problem is the 2 data sets are displayed in the chart with 2 different scales.

The monthly sales y-axis scale (on the left) doesn't match the monthly quota y-axis scale (on the right).

So you lose the ability to visually see the comparison (actual vs. quota).

Is there some hidden way to force the scales to be the same?

Thanks, Kevin.

Need an account? Sign Up

Have an account? Sign In