I have a column chart, I would like to show the total, which on the data is easily provided by ticking the Row Totals box.
But on the chart this column is obviously far larger than any of the other columns. I can easily change this to a line from a column by finding the Row Total in the series options of the chart. But I want it to obviously be on a separate Y Axis so it doesn’t dwarf the other columns.
I think a lot of information I’m finding is a bit out of date, but in the options it looks like I can move the entire Series to a second Y Axis, but not the Row Totals individually.
Is there an option I’m missing? At the moment I’ve got a line that tops out at 1300+ and columns that often barely hit 50, so they’re difficult to read