Dynamic charts are awesome. But, do you know what is the most important part of a dynamic chart? “Dynamic Chart Title”.
Yes, dynamic chart title.
Creating dynamic chart title in excel is one of the best ways to make your charts interactive.
It will help you to show what actually your chart is about.
Ahead in this post, you will learn how to create dynamic chart title in excel.
Why you need a Dynamic Chart Title?
Chart title is the header of a chart which delivers a clear message to the user about the chart.
Let’s say you have created a dynamic chart in which values will change when current year change.
But what about chart title, you have to change it every time.
And, there is always a chance of missing it.
Let me show why there is no need to worry about this.
You just have to create a dynamic chart title in your chart & you are free.
Steps To Create Dynamic Chart Title
Converting a normal chart title into the dynamic chart title is simple.
But before creating your chart’s name dynamic you need a cell which you have to link with the title.
So that chart title will change with cell value.
- Select chart title in your chart.
- Go to the formula bar & type =
- Select the cell which you want to link with chart title.
- Hit enter.
The main idea to make a chart title dynamic is that you need a cell to link with it.
When you link chart title to a cell and when there is a change in the cell, title in your chart will change.
Combine Cell Link & Text to Create a Dynamic Chart Title
As you know dynamic chart titles are worth to use.
Now, let me show you that you can also combine cell link with text to add some extra sauce in your chart title.
For example, if you want to link a cell having a year name which will change with chart data & you want to add a label “Monthly Sales Trend:” before it.
- First of all, just enter the below formula in a new cell.
- Select the chart title.
- Go to formula bar & press =
- Now, just select the new cell.
- Hit enter.
This type of text combination with cell link will help you to describe your chart. You can also use concatenate function to combine text in the cell.
You can also use concatenate function to combine text in the cell.
Creating Dynamic Chart Title in Pivot Chart
You can also use this method to create dynamic chart title in 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 the space from your chart you can also use a 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.
By using shapes as a chart title you get more space.
Things to Remember
- You can’t use formulas 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.
A dynamic chart title is all 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.
Using dynamic chart title in excel is a must to make a chart dynamic. This will help you to deliver a strong message to your user about the chart.
You can create dynamic chart title in excel charts, pivot charts & by using shapes as chart titles.
Over To You
Now, tell me one thing.
Have you ever used dynamic chart title in your charts?
And, do you have any other way to add a dynamic chart title?
Share with me in the comment box.