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
 
Back
Top