Скачать или смотреть How to Create Dynamic Chart Titles in Excel

A viewer wanted my help to create titles in his Excel charts that dynamically updated to show - e.g. a Customer Name in the Chart title - when he "filtered" the source data behind his chart.

The solution is simple - you create a formula that, first, references the Customer Name to include in the Chart Title. Then, you create a link from the Chart Title, itself, to the cell with this formula.

In the video, I show you step-by-step how to do this as well as how to "hide" the formula.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video lessons and also to take advantage of the many resources that I offer.

Danny Rocks
The Company Rocks