Adding Grand Total from Pivot Table to Chart.

[emiliaw.]

Hello,

I have a bar chart set up off of data in a pivot table, but I cannot figure out how to add the Grand Total from the Pivot Table as one of the bars on the chart. This is the data that I have. I want the last row of data, grand total, included in my bar chart. Can anyone help?
[TABLE="width: 511"]
<TBODY>[TR]
[TD]</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Values[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Count of Claim_Number[/TD]
[TD]Count of Claim_Number2[/TD]
[/TR]
[TR]
[TD]0-7 days</SPAN>[/TD]
[TD] 790 </SPAN>[/TD]
[TD="align: right"]10%</SPAN>[/TD]
[/TR]
[TR]
[TD]8-14 days</SPAN>[/TD]
[TD] 1,390 </SPAN>[/TD]
[TD="align: right"]17%</SPAN>[/TD]
[/TR]
[TR]
[TD]15-28 days</SPAN>[/TD]
[TD] 1,516 </SPAN>[/TD]
[TD="align: right"]18%</SPAN>[/TD]
[/TR]
[TR]
[TD]29+ days</SPAN>[/TD]
[TD] 4,594 </SPAN>[/TD]
[TD="align: right"]55%</SPAN>[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD] 8,290[/TD]
[TD="align: right"]100%[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]

 

[Robert Mika]

You can not.
Please see link to explanation:
[SOLVED] How do I show the Grand Total on a Pivot Chart?