A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Scatter Plot -- label individual points



 
 
Thread Tools Display Modes
  #1  
Old September 30th, 2004, 12:17 AM
Gail
external usenet poster
 
Posts: n/a
Default Scatter Plot -- label individual points

I have 30 pairs of numbers that represent estimates from
two sources for 30 counties. I would like to label each
point on the scatter chart with the county name. My file
looks like:

county A est 1 est 2
county B est 1 est 3
and so on

I've tried creating each pair of numbers as a data series,
but then I can't produce a trend line (which I need to do).
Any suggestions will be greatly appreciated. Thank You!
  #2  
Old September 30th, 2004, 01:48 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

You can use Rob Bovey's XY Chart Labeler to add the labels. It's a free
add-in that you can download from his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


Gail wrote:
I have 30 pairs of numbers that represent estimates from
two sources for 30 counties. I would like to label each
point on the scatter chart with the county name. My file
looks like:

county A est 1 est 2
county B est 1 est 3
and so on

I've tried creating each pair of numbers as a data series,
but then I can't produce a trend line (which I need to do).
Any suggestions will be greatly appreciated. Thank You!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
XY Scatter with points labeled, but not with the coordinates of the points, the point names? Cardinal2B Charts and Charting 1 March 11th, 2004 11:37 PM
Too many points on xy scatter plot! Steve Charts and Charting 5 January 1st, 2004 12:27 AM
Scatter plot changes to line plot with data gaps Jim Charts and Charting 14 October 8th, 2003 05:10 PM


All times are GMT +1. The time now is 06:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.