I have a problem with an Excel chart.
- a primary axis (two series), showing volumes in millions
- a secondary axis showing percentages (one series)
The primary axis seems to be adding the two series together and then posting an equivalent whole number of the total as the maximum. If you also look at the chart, the lesser volume series is appearing above the bigger volume series.
What could be the problem?