I used line but you could have used a column chart on the secondary axis.
The criteria is that you want to display information about the total of the data in the chart without the total series distorting the rest of the charts data.
If you left it as a stacked column then all the other values would be squashed and the maximum value of the Y scale would be twice as big as necessary.
So changing the chart type or axis will get around this problem.
Bookmarks