Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Charting (XP)

    I'm trying to create a price chart in Excel. Is it possible to add comments/annotations to the price chart on specific dates. And maybe point those comments to the corresponding dates using an arrow? Is it possible or do I need an additional add-in?

    Thanks in advance for all the help.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Excel Charting (XP)

    You can use the drawing tools in Excel to draw text boxes and arrows. Have you used the drawing tools before?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Putnam Valley, New York, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Charting (XP)

    After a line chart or XY scatter chart is drawn, it's possible to select an individual point, turn on data labels for just that point and turn those data labels into "comment boxes." The boxes usually need to be moved for legibility and if data is added or changed, may have to be "redrawn". I did work at a place that developed a macro for commenting boxes precisely for price charts, but no longer recall specifics. I've attached a very short example. As mentioned above, it usually easiest to draw arrows using the draw toolbar, once the points have been marked

  4. #4
    New Lounger
    Join Date
    Jul 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Charting (XP)

    This is really helpful. Thanks for the help guys!!!

Posting Permissions

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