Results 1 to 8 of 8
  1. #1
    mikpar
    Guest

    How to insert date automatically in chart title?

    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

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    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.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    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.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    OK, that's better than my solution
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    mikpar
    Guest

    Re: How to insert date automatically in chart title?

    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

  6. #6
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    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.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    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?

  8. #8
    Star Lounger
    Join Date
    Feb 2001
    Location
    Auckland, North Island, New Zealand
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert date automatically in chart title?

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •