Excel - Dynamic Chart Date: Episode 1398

3,416 views · Published 5 May 2011 · 2:28 · Indexed 14 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Add a Dynamic Date to Your Excel Chart | Excel Tips & Tricks | MrExcel Podcast.

Welcome back to the MrExcel Podcast! In this episode, we will be discussing how to add a dynamic date to your Excel chart. This is a common question that I often receive during my seminars and I have a great solution for it. But first, I want to thank our sponsor, MrExcel.com, for making this podcast possible.

So, let's dive into the problem. You have a chart with a Chart Title and you want to include the current date at the top of the chart. The catch is, the chart is on its own sheet and you want the date to update automatically. Well, I have a cool trick for you. First, go back to the data worksheet where the data for the chart is located. In cell B1, enter the formula =TODAY(). This will give you the current date.

Next, we will use the TEXT function to format the date the way we want it to appear on the chart. In cell B1, enter the formula ="Data through "&TEXT(A1,"mmmm d, yyyy"). This will give you a text string that says "Data through [date]". Now, pay attention to the name of the sheet because we will need it later.

Now, let's go back to the chart sheet. Click on the Chart Title and in the formula bar, enter =Data!$B$1. This will link the chart title to the cell where we have our dynamic date formula. And voila! Your chart title will now update automatically with the current date.

Just a quick note, if your chart and data are on the same sheet, you still need to include the full name of the sheet in the formula. And if your sheet name has a space, like "Income Statement", you will need to include apostrophes around the sheet name in the formula.

And there you have it, a simple yet effective way to add a dynamic date to your Excel chart. I hope you found this tip useful. Don't forget to tune in next time for more Excel tips and tricks from MrExcel. Thank you for watching and see you in the next netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Adding Current Date to Chart Title
(00:32) Using the TODAY Function
(00:45) Formatting the Date with the TEXT Function
(01:05) Selecting the Chart Title
(01:18) Editing the Formula
(01:35) Reflecting the Formula in the Chart Title
(01:45) Limitations of the Formula
(02:14) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Chart Title
Current date
Date The Chart
Dynamic chart title
Episode 1398
Formula in Excel
Learn Excel
Text function in Excel
TODAY function
Worksheet name in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153076/

Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished.

...Learn Excel 97-2007 from MrExcel.

More from this channel