• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Update text box with (dynamic) value from a Pivot Chart

D

DAOJ

New Member
I've created a dashboard, with a chart and slicers.
I'd like the yellow text boxes to update to show values from the chart which of course will change as the user interacts with the slicers.
In the screenshot, the # of testers = 1, and the number of tests = 6.
If I was to adjust the slicer to also include NZ data, then the # of testers would increase to 2, and the number of tests = 10.
The text boxes should update as the chart changes.
NB I'm not using a pivot table as such, just pivot charts

1729647578644.png
 
Text boxes don’t update automatically with slicers. Link the text box to a helper cell that uses GETPIVOTDATA from the pivot table connected to the slicer. Once the cell updates, the text box will refresh dynamically. Keep the pivot hidden if needed.
 
You must log in or register to reply here.
Back
Top