Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
10000+ Copies Already Downloaded
We all love dynamic and interactive charts. They are awesome.
But, do you know what is the most important part of a dynamic chart?
That’s ==> Chart Title
A dynamic chart title in excel is must to have to make charts interactive.
Just think this way:
You have created a dynamic chart in which values will change when current year change. But what about chart title, you need to change it every time.
The bad news is, there’s always a chance of missing it.
But here is the good news, you can link a chart title with a cell to make it dynamic.
And in today’s post, I’m going to show you exact steps to make a chart title dynamic by connecting it to a cell.
So, let's get started.
Converting a normal chart title into a dynamic one is simple. But before that, you need a cell which you can link with the title.
Here are the steps:
Now, let me show you how to combine a cell and a text to create a dynamic chart title.
For example, if you want to link a cell having a year name which will change with chart data and you want to add a label “Monthly Sales Trend:” before it.
=”Monthly Sales Trend: ” &H3
You can also use the same method to create a dynamic title in a pivot chart. Once you create a pivot chart, use the same steps as you have used in a normal chart.
If you want to save some space from your chart then you can also use a separate rectangular shape as a chart title.
Download sample file from here to learn more.
A dynamic chart title depends on a cell that has a formula which will change when you change
So basically, your chart title is linked to a cell which is dynamic.
I hope this charting tip will help you to create advanced charts.
Now tell me one thing. Have you ever used a dynamic title in a chart before? Please share your views with me in the comment section, I would love to hear from you.
And, please don’t forget to share this tips with your friends.