Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart Data Labels (2003)

    I'd like to add data labels that aren't the data values to chart points. These labels are calculated on the source worksheet, so I'd like to avoid editing each label individually. One way I've found to do this is to specify "Category Name" as the "Label Contains" option in the Format Data Series dialog (Data Labels tab) and specify the desired labels as the Category (X) Labels in the Source Data dialog. Trouble is, I'd also like to label the X-axis with another series and I have several other series on the chart that I'd also like to label with different values (still different from the y-values). Is there any way to do this in Excel?

    Thanks,

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

    Re: Chart Data Labels (2003)

    Rob Bovey has written a free add-in: XY Chart Labeler. It works with other chart types than XY charts too. It lets you specify a range to act as data labels.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Data Labels (2003)

    Thanks, Hans. I'll give it a try.

Posting Permissions

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