Include Totals in a chart

[#1]

Hi all,

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?

thanks,

Tony

[#2]

Don't worry everyone, panic over, I fixed it.

I had to select Sum of Rows on the Expressions tab.

Tony