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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |