Link Excel Chart Title to Cell with Pivot Table Filter
See how to link Excel chart title to cell, with this Pivot Chart example. Instead of typing the Title text, you can add a worksheet formula to create a dynamic title.
Then, link the Chart Title to your formula cell, and the chart title changes automatically, when you select a different item in the Pivot Table Report Filter.
To follow along, you can download the pivot chart sample file on my Contextures website.
https://www.contextures.com/pivotchar...
00:00 Intro
00:19 Add a Pivot Chart
01:14 Add a Chart Title
01:57 Region Filter
03:01 Create a Formula
03:22 Formula Rules
04:02 Start the Formula
06:52 Link Title to Formula Cell
07:51 Get the Sample File
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...