Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Wausau, Wisconsin, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 - add cell comments to chart (Office 2000)

    Does anyone have a way to attach a comment in a cell to a chart without manually creating text boxes? Example: Quality Management tracks outcomes via Excel spreadsheets. If the "numbers" are up or down, they commonly attach a comment to the cell for explanation. When charting this information, the comments would be extremely useful but I haven't found a way to get them there other than the manual way (cumbersome!)

    Any thoughts?

  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 2000 - add cell comments to chart (Office 2000)

    Are you using Insert, Comment? Comments offer a couple of advantages over text boxes. If you are using the comments feature already, then let us know.

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

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Wausau, Wisconsin, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 - add cell comments to chart (Office 2000)

    Sorry, I need to clarify. I already have the comments inserted in the worksheet. But when I chart it (using F11 or the wizard), there isn't a way, that I've found, to transfer the comment for that cell's data, to the chart without the manual insert text box. Does that make a bit more sense?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel 2000 - add cell comments to chart (Office 2000)

    (Edited by HansV to update link to Excel MVP site)

    What about datalabels, linked to a point?

    Datalabels are best handeled in VB if there are lots of points:
    Here is a site that has an excellent addin (XYchartlabeler by Rob bovey)
    http://www.bmsltd.ie/mvp/

    Steve

Posting Permissions

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