Forum Discussion
Add (today) date within body of Excel chart
(I'm a novice user of Excel-Office Pro 2019) I have a number of charts within Excel files that show data of performances over weeks and months. I know this is a simple question, but its driving me crazy. I want the chart to show "today's" date in or near the "Chart Title". I have a cell in the worksheet - B1 with =TODAY(). Works fine - 1/22/2021 etc... What/how do I get the 1/22/2021 to show in the chart? (For viewing, not as a header/footer for printer page.) I've tried using insert text box, date is not dynamic.
Thanks, Steve
4 Replies
Click on the chart title.
Type = and point to the cell containing the =TODAY() formula, then press Enter.
I did as you said, it deleted the original title and replaced it with the date. How do I keep the original title "January Sales figures" and add the date (cell B1) 1/22/2021. So it reads "January Sales figures 1/22/2021"
Steve
