Show Subtotal In Pie Chart? Possible?

[#1]

Hi guys,

Has anyone found an easy way of showing the total all records shown in a pie chart? I have a pie chart with the numbers shown alongside the legend. typically, I would like to show the sum of the numbers in the legend. I know I could create a text box but i am supressing nulls etc in my chart so I don;t think it would be the most efficient method. Any Ideas?

Thanks,

[#2]

bcolgan85 I've run into the same challenge and can't figure out an elegant solution to this. See below, like you said you can add a text box but that's not going to dynamically format like a total of all records. Any suggestions from the community other than a text box would be appreciated. Thanks

[johnw]

Well, I'm not sure it's elegant, but on the presentation tab, you can add text in chart, with an expression like:

='Total = ' & sum(Value)

Then control shift the chart and drag the total wherever you want it. It's still text, but at least it's part of the chart.