Show total at data table bottom (and hidden in stack)

[ahearnden]

Please see attached picture - the data source includes a "Year total" column which is coloured white in the chart; I've included it because the requirement is to show year total in the data table underneath the chart. Is there a way that year total can be the final row of the data table and not the top row, whilst keeping it at the top of each year's stackAttachment 376955? Thank you for any help

[Andy Pope]

Hard to help with just a picture to work from.

Try using the Select data dialog to alter the plot order.
Also change Year Total series to line.