nigh on impossible charting question - now answered

sann0638 · Apr 4th, 2002, 04:50 AM

Three lines of data:
1:US state
2:Numeral one
3:Numeral two

Chart required - scatter showing the state on the chart next to the point with x-value numeral one and y-value numeral two. Should be easy, but isn't obvious to me.
Thanks,
Mike

[ This Message was edited by: sann0638 on 2002-04-08 03:56 ]

[ This Message was edited by: sann0638 on 2002-04-08 07:54 ]

shades · Apr 4th, 2002, 09:42 AM

On the chart, right click, and select "Chart Options." Go to "Data Labels" tab, select "Show Value" and then at the bottom select "Legend Key next to Label."

HTH

sann0638 · Apr 5th, 2002, 12:46 AM

Sorry - should have been clearer. Doing what 'Shades' suggests only works (as far as I can tell) for putting labels next to two separately plotted lines of data - not for points that have an x and y value and a label. I may be missing a step, and would appreciate it if someone could fill me in.

eliW · Apr 5th, 2002, 07:46 AM

Just to bring attention to this tough question.
Is there any way to attach automatically text labels to each points in x,y chart ?

[ This Message was edited by: eliW on 2002-04-06 10:49 ]

eliW · Apr 6th, 2002, 11:51 AM

sann0638,
It seems that it can't be done.

sann0638 · Apr 8th, 2002, 01:49 AM

There's a blow. A colleague did it in Lotus, but I would rather not resort to this! Perhaps Monday morning will shed some light...

Mike

SamS · Apr 8th, 2002, 03:14 AM

There was a similar question a couple of days back and there was a link to another site for an add on - may be of use to you.

http://www.mrexcel.com/board/viewtop...c=4142&forum=2

klb · Apr 8th, 2002, 06:40 AM

If I understand what you want:

Use the chart wizard, select the first example for XY(Scatter). Then for Data Range, select all of your data. For Series, select the range with your state names for both the "X values" and "Y values"

Under Data Labels, you need to check "Show Label" and not "Show Value".

sann0638 · Apr 8th, 2002, 06:57 AM

I don't think this does exactly what I want, although I may be misinterpreting what you have written. Apologies if so, but could you make it a bit clearer.

To restate the issue:
the graph is an x-y chart, for example plotting Texas(3,4), New York(5,1), Mississippi(2,7). I want points shown at (3,4), (5,1) and (2,7) called Texas, New York, Mississippi.

Jay Petrulis · Apr 8th, 2002, 08:46 AM

Quote:

On 2002-04-05 06:46, eliW wrote:
Just to bring attention to this tough question.
Is there any way to attach automatically text labels to each points in x,y chart ?

[ This Message was edited by: eliW on 2002-04-06 10:49 ]

Hi All,

Yes it can be done. The best way is to download Rob Bovey's Chart Labeler add-in from the Free Utilities section on his website

http://www.appspro.com/

This will do what you wish automatically.

Bye,
Jay

Edit: I see that Sam S has already mentioned this and John W.'s option in the PUP2000. Sorry for the duplication.

[ This Message was edited by: Jay Petrulis on 2002-04-08 07:49 ]

Apr 4th, 2002, 09:42 AM	#2
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	On the chart, right click, and select "Chart Options." Go to "Data Labels" tab, select "Show Value" and then at the bottom select "Legend Key next to Label." HTH __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 04:50 AM	#1
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Three lines of data: 1:US state 2:Numeral one 3:Numeral two Chart required - scatter showing the state on the chart next to the point with x-value numeral one and y-value numeral two. Should be easy, but isn't obvious to me. Thanks, Mike [ This Message was edited by: sann0638 on 2002-04-08 03:56 ] [ This Message was edited by: sann0638 on 2002-04-08 07:54 ]

Apr 5th, 2002, 12:46 AM	#3
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Sorry - should have been clearer. Doing what 'Shades' suggests only works (as far as I can tell) for putting labels next to two separately plotted lines of data - not for points that have an x and y value and a label. I may be missing a step, and would appreciate it if someone could fill me in.

Apr 5th, 2002, 07:46 AM	#4
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	Just to bring attention to this tough question. Is there any way to attach automatically text labels to each points in x,y chart ? [ This Message was edited by: eliW on 2002-04-06 10:49 ]

Apr 6th, 2002, 11:51 AM	#5
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	sann0638, It seems that it can't be done.

Apr 8th, 2002, 01:49 AM	#6
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	There's a blow. A colleague did it in Lotus, but I would rather not resort to this! Perhaps Monday morning will shed some light... Mike

Apr 8th, 2002, 03:14 AM	#7
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	There was a similar question a couple of days back and there was a link to another site for an add on - may be of use to you. http://www.mrexcel.com/board/viewtop...c=4142&forum=2

Apr 8th, 2002, 06:40 AM	#8
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	If I understand what you want: Use the chart wizard, select the first example for XY(Scatter). Then for Data Range, select all of your data. For Series, select the range with your state names for both the "X values" and "Y values" Under Data Labels, you need to check "Show Label" and not "Show Value".

Apr 8th, 2002, 06:57 AM	#9
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	I don't think this does exactly what I want, although I may be misinterpreting what you have written. Apologies if so, but could you make it a bit clearer. To restate the issue: the graph is an x-y chart, for example plotting Texas(3,4), New York(5,1), Mississippi(2,7). I want points shown at (3,4), (5,1) and (2,7) called Texas, New York, Mississippi.