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
By creating a dynamic chart title you can make your Excel charts more effective.
Just think this way. You have created a dynamic chart in which values will change when current year changes. 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’d like to share with you exact steps to make a chart title dynamic by connecting it to a cell.
Let’s get started.
Steps to Create Dynamic Chart Title in Excel
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:
- Select chart title in your chart.
- Go to the formula bar and type =.
- Select the cell which you want to link with chart title.
- Hit enter.
Related: Top 10 ADVANCED Excel Charts and Graphs (Free Templates Download)
Combine Cell Links and Text to Create a Dynamic Chart Title
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 that will change with chart data and you want to add the label “Monthly Sales Trend:” before it.
- First of all, just enter the formula (
=”Monthly Sales Trend: ” &H3) in the formula bar in a new cell. - Select the chart title.
- Go to the formula bar and press =.
- Now, just select the new cell.
- Hit enter.
Creating Dynamic Title in Pivot Chart
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.
Create a Dynamic Chart Title with Shapes
If you want to save some space from your chart then you can also use a separate rectangular shape as a chart title.
- Just insert a shape into your worksheet.
- Link it to the cell as you have linked the cell in normal chart title.
Important Points
- You can’t use formula in chart title, but you can link it with a cell having a formula.
- If you want to enter a line break in chart title you can create that line break in the cell you are linking to.
Sample File
Download sample file from here to learn more.
Conclusion
A dynamic chart title depends on a cell that has a formula which will change when you change value in your chart. 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 ans now tell me one thing.
Have you ever used a dynamic title in a chart before?
Share your views with me in the comment section, I’d love to hear from you. And please don’t forget to share this tip with your friends.
More Charting Tips and Tutorials
- How to Add a Horizontal Line in a Chart in Excel
- How to Add a Vertical Line in a Chart in Excel
- How to Create a Bullet Chart in Excel
- How to Create a Dynamic Chart Range in Excel
- How to Create a Sales Funnel Chart in Excel
- How to Create a HEAT MAP in Excel
- How to Create a HISTOGRAM in Excel
- How to Create a Pictograph in Excel
- How to Create a Milestone Chart in Excel
- How to Insert a People Graph in Excel
- How to Create a Population Pyramid Chart in Excel
- How to Create a SPEEDOMETER Chart [Gauge] in Excel
- How to Create a Step Chart in Excel
- How to Create a Thermometer Chart in Excel
- How to Create a Tornado Chart in Excel
- How to Create Waffle Chart in Excel
Sr, please share, how to create dynamic chart of this tutorial…
I want to create a dynamic pivot chart title to describe the count of part-time & full-time and male & female hires (horizontal axis) along with the Month, Quarter, or Year (vertical axis) for drill downs. Is that possible?
Wow – no idea that it would be so simple. I have used Excel for 20 years in my career and for some reason never knew I could put a formula in as the Title. What a blessing you are to share such a simple task and educate us.
your words are blessings too. 🙂
Linking the title to a cell works for scatter plots and histograms, but I can’t get it to work with boxplots. Selecting the title in a boxplot deactivates the formula bar. Bummer.
You just saved me a lot of time and prevented a lot of mistakes!! Thanks!!
I’ve tried this countless times and researched to see if there was more to it, but like always I have failed. I am not sure why but every time I click on the chart title, the formula bar goes off. I need help!
Great, thanks
it is in excel sheet your sample file but cannot see the chart bar changing even though it is downloaded correctly, we have to convert to see , where we can see the bar change
Linking to a cell with a formula is a nice workaround for lack of direct formula in the title. Good one.
Thanks for your words Dinesh