Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    64
    Thanks
    1
    Thanked 1 Time in 1 Post

    Excel 2003 Charts (Excel 2003)

    Hi all

    Is there any way to insert a worksheet cell showing the current month, or a date, in an Excel Chart. This does not form part of the data series, it is simply to identify the correct period for the data, but I don't want to have to add it manually each month

    thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2003 Charts (Excel 2003)

    Yes:
    - Click on the chart to select it
    - Type = then point to the worksheet cell; you should see something like =Sheet1!B2 in the formula bar.
    - Press Enter.
    - A text box bound to the worksheet cell will appear on the chart.
    - Drag it to where you want it.
    - Format it the way you like.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel 2003 Charts (Excel 2003)

    <P ID="edit" class=small>(Edited by Rudi on 03-Jan-08 20:04. I have found a work-around! See below...)</P>Hans,
    I am aware of this feature described and have done it many times on charts in 2003 and earlier. I have tried to do this in Excel 2007, but it does not add a text box linked to a cell. Ihave tried it several times on two seperate charts in 2007, and it does not work. I am assuming the method has changed in 2007?! (I cannot believe that this functionality has been removed). <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Can anyone else using 2007 confirm this please?
    TX

    Work-around...
    Activate the chart,
    Insert a textbox on the chart area (select the text box from the Layout tab on the Chart Tools ribbon)
    With the text box active, click in the formula bar
    Type = and then select a cell with the content for the chart
    Enter
    Move and size the text box accordingly
    Regards,
    Rudi

Posting Permissions

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