How to use GETPIVOTDATA in a textbox on a graph

[andrewbroadway]

First, thanks to everyone who helps!


I'm simply:


1. Inserting a textbox from the Layout tab of the selected graph.

2. Inside of the formula bar, having the text box selected, inserting an '='

3. Then clicking on the Grand Total of a PivotTable

4. This formula appears =GETPIVOTDATA("otapct",Presentation!$S$1)

5. I click the check box to confirm the formula


Then I get this error:


The formula you typed contains an error.


What am I doing wrong? How do I use the GETPIVOTDATA formula inside a textbox on a graph?

 

[Hui]

Andrew


The only formula you can have in a textbox is a =Cell Reference


So simply link another cell to your Pivot Table and then link your text box to that cell

eg:

H1: =GETPIVOTDATA("otapct",Presentation!$S$1)

then in the text box

=H1

 

[jack520]

I am a new here ,look forward to make more friends here ,thank you. Coach Factory Outlet

CoCo Chanel

Coach outlet