Date variable in a chart title

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How do you enter a date variable into the title for a
chart??. I want to have the current date in the title of a
chart I have made.
 
Steve -

Put the title you want into a worksheet cell, which can contain a formula:

="Today's date is "&TEXT(TODAY(),"DD-MMM-YYYY")

Now select the chart title, press the = key, select this cell with the
mouse, and press Enter. The title will always say what's in this cell,
even when the cell updates.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Variables in Chart titles? 7
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Date in Chart Title 2
Current date (i.e., today()) in Chart Title 7
Dynamic Chart title and text formula? 1
Office 07 Excel chart title position 1
Display Data Table in chart but don't show plot area 2

Back
Top