Adding grand totals to pivot chars

[Optimesh]

Hello all,
I was wondering if there's a way to "make" the pivot charts plot the line for the grand total column as well... not just the "inner" columns.
Suggestions would be highly appreciated.
Thanks!

 

[cyrilbrd]

Hi,
Why not making a chart that is NOT a pivot chart?
Just select the range of preference (including Grand Total).

 

[Optimesh]

Hi,
thanks for your reply.
One reason is that I'd like to update the data, and hence the chart on occasion. The updates might change the dimensions of the table, which would require extra work updating the regular chart.

Hi,
Why not making a chart that is NOT a pivot chart?
Just select the range of preference (including Grand Total).

 

[cyrilbrd]

Could you use =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A)) or GETPIVOTDATA to make it dynamic?
Just a thought.

 

[Optimesh]

could you please elaborate?

 

[cyrilbrd]

GETPIVOTDATA
that link describe the basic use of the above mentioned formula. Note the syntax, this allowing you to retrieve ant data from a pivot. Such would permit you to create a dummy range that would dynamically be linked to your PT.

 

[Optimesh]

thank you! i'll check it out soon!