Solved

Labeling the data points in XY scatter plot (Excel 2000)

Posted on 2001-07-25
6
530 Views
Last Modified: 2007-12-19
I like to label the data points in a XY scatter plot using the characters in a column. I have 3 columns of data. The first two columns are the data of X and Y coordinates and the third one contains the index of each data point.
In the Excel, there are 'chart options' which label the data points, such as "show value" and "show lable". However, these options use only the data in the first two columns. Is there a simple method to label the data point using the data in the third column ?

Thanks for the help.

TKC
0
Comment
Question by:tkchen
  • 4
  • 2
6 Comments
 
LVL 13

Expert Comment

by:cri
Comment Utility
Download the XY Chart Labeler at http://www.bmsltd.co.uk/MVP/Default.htm

It is free and it works a charm (for Excel 97, therefore test it)
0
 
LVL 13

Expert Comment

by:cri
Comment Utility
The inherent trick, linking a cell to the _textbox_ of a series label, can be done manually. If interested, ask.
0
 
LVL 1

Author Comment

by:tkchen
Comment Utility
CRI
thanks for your help. The XY Chart Labler works well. If you can show me your trick, I like to learn it.

thanks again.

TKC
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 13

Accepted Solution

by:
cri earned 100 total points
Comment Utility
The trick is simple but somewhat risky if applied on data points. End of mealy mouthed disclaimer.

Select a data single point, a four pronged arrow will appear . Make sure you do not move it or you will change the X or the Y value, no kidding. Right click it, again without trembling. Select 'Format Datapoint'. Select 'Data Labels'. Select 'Show Label or Value, does not matter. Select data label _textbox_. In the Formula Bar (View|FormulaBar) _write_ '=' (w/o quotes) then select the applicable cell. Thats all.

You can apply this trick to the chart and axis titles, and any textboxes or shapes too.
0
 
LVL 1

Author Comment

by:tkchen
Comment Utility
CRI,
    Thank you very much. It works very well. I appreciate you help.

TKC
0
 
LVL 13

Expert Comment

by:cri
Comment Utility
ThAnk you.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now