View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default displaying totals in a pivot chart

In a blank cell in the workbook, type an equal sign, then click on the
grand total cell in the pivot table. Unless you've changed the default
settings, this should create a GETPIVOTDATA formula, such as:
=GETPIVOTDATA("Total",$A$3)
Format the cell as you want it to appear on the chart.

Next, select the pivot chart and type an equal sign. You'll see it in
the formula bar as you type.
Then, click on the cell with the GETPIVOTDATA formula, and press Enter

The grand total will appear in a text box in the centre of the pivot
chart. Drag it to the position you want it displayed, and format it.

Josh Smith wrote:
I want to display the grand total from a pivot table in a pivot chart. In a
static chart I normaly just reference the cell with the total to be displayed
as the chart title. How can I do this with a pivot chart.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html