I am trying to put together a Pivot chart and would like to have two values associated with each of our products, each displayed on a separate bar. One of these bars is Sales (Tonnes), and the other is sales vs. month target as a percentage. So these values need separate scales and axes for the chart to be meaningful.
I have the values on separate axes but the chart is combining them to overlap. Please see the following:
Can I just have two separate bars with two separate axes?