I have created a chart with Type = Straight Table and on the Presentation sheet I have Totals on Last Row selected and I have entered MyTotal as the label.
However, in the chart I just get MyTotal -
Can I have Totals in a Straight Table or do I have to use a Pivot table?
Don't worry everyone, panic over, I fixed it.
I had to select Sum of Rows on the Expressions tab.
Retrieving data ...