Have you ever wanted to change your chart title dynamically?
Perhaps you wanted to link it to a cell value?
Did you know that it is possible?
It is really easy to do, but some find it tricky to implement.
In this post, you will learn how-to link an Excel Chart Title to a cell within your worksheet. That will make it dynamic so that as you change the cell in the worksheet, it will dynamically change the chart title.
You can see in this chart that the chart title is linked to cell A1. Here are the steps to make your chart title dynamic…
1)Click on the Chart
Well maybe I should have said that you need to create a chart. Then, add a chart title to your chart if it was not added when you created your chart. Then, you will need to do is click on your chart.
2)Click on the Chart Title
Now that you have selected the Excel Chart, you will need to click on the Chart Title in order to make it a dynamic chart title.
3)Press the “=” sign on your keyboard
This is the easy but the critical step to make your Chart Title Dynamic.
4) Click on the Excel Worksheet Cell to Dynamically Link the chart title to that worksheet cell.
After you press the “=” sign, then simply click on a cell that you want to link the Chart Title. See in the Excel Formula Bar that after you press “=” you can now link to a worksheet cell. If you don’t press the “=” sign first, you will just change control of the worksheet to the cell instead of creating the Dynamic Excel Link.
The final step is to simply press the ENTER Key. This will lock in your Dynamic Title for your Excel Graph.
It was that simple, but if you don’t Press the “=” sign, you will not be able to make the Dynamic Excel Chart Title. Below you can watch a video of this in action, a FREE sample file and don’t forget to sign up for my blog so that you will get the next post.
You can get a FREE 2003 and Above sample template download file with instructions here:
Please don’t forget to sign up for my newsletter and also leave me a comment on the other types of charts you would like to see.
Oh that was so easy!!
thanks a ton mate.
awesome. i consider myself an expert excel user and never thought that was possible!
Thanks Dan. Glad to help. Steve=True
That was easy ,,, but never crossed my mind 🙂 ,,, cheers mate
Thanks for the kind comment. Cheers 🙂 Steve=True
I love you. So simple, so elegant and told to us so very well.
Thank you SO much!
Thanks Geeky Squirrel. You are very welcome. Glad that it worked for you. Thanks for the kind comment. Steve=True
graph yang menarik
ini mudah dipahami
terima kasih infonya
Thanks for the great comments. Steve=True