How to insert date automatically in chart title?

Topic

New Reply

I update a large worksheet every day from which a series of charts are generated. The date for the current data appears in a cell on the worksheet (A4). I would like this date to appear in the TITLE of each linked chart. but I haven’t been able to figure out how to accomplish that. Presently I have to manually edit the title of each chart to include the date. Does anyone have any ideas on how to accomplish this? Thanx.
Mike

Reply | Quote

Replies

Just select the chart title then, in the formula bar, type an equal sign (=) then select the cell that you want entered in the title and press enter.

Reply | Quote

OK, that’s better than my solution

Reply | Quote

Thanks! that works great. I managed to keep the rest of my title on the chart by placing it in a separate text box centered of the date. My title line now tow lines instead of one, but I don’t have to manually update 12 chart titles every day. Thanks again.

Mike

Reply | Quote

Hey Mike,

I just tried an additional test. Instead of using two title boxes to contain the information you want, you can also reference a range of cells for the title data. I tried inserting some text in one cell (i.e. “Today’s date is:”) and the formula =TODAY() in the next cell to it. I then selected both cells for my Chart Title in the formula bar and it properly displayed both together. Just a thought.

Reply | Quote

I just tried this and all I got was the information from the first cell. I’m using Excel 97. Anyone know of a macro to use for this and also for getting special information into the header of tables that you print. Also, how do you get headers inserted into the Header and Footer boxes in the Print Page Setup Screen?

Reply | Quote

Mike,

Record your actions in the macro recorder; then manually edit the macro so that it inserts today’s date.

If you need help with editing macros, get back to the forum.

Reply | Quote

For adding a date to excel chart I always use a cell with text and formula combined (eg =”today is “&now()) then use a text box in the chart pointing to that cell. Drag and format this text box to act as chart title.

A macro including code below lets you update the headers and footers on a sheet

With ActiveSheet.PageSetup
.CenterFooter = “”
.RightFooter = font_set & “” & Chr(10) & “Page &P of &N”
end with

Reply | Quote