Customizing a Pivot Chart

[Guest]

I just completed a pivot table and pivot chart for a customer. The customer
requested additional information on the pivot chart sheet. In this case he
would like a the grand total sum displayed as a numeric value in a box just
off the chart. Is it possible to display a cell value and a label randomly
on the pivot chart sheet? What does it take?

 

[Debra Dalgleish]

You can display the contents of a worksheet cell on the pivot chart:

Select the pivot chart
Type an equal sign
Select the worksheet cell for which you want to display the value
Press the Enter key
Move the text box from the centre of the pivot chart to the location you
want to display it.