XY (Scatter) Chart - question regarding markerstyle/label

andy-s · Mar 23rd, 2002, 04:23 AM

Column A consists of names like AA, BB, CC.
Column B consist of values like 2.2, 3.4, 3.6
Column C also consist of values like .7, .6, .3

I've no problem with making an ordinary xy plott. BUT, instead of the traditional square markerstyle, I would like the name of xy value. (e.g AA for the 2.2 and .7 plott)

I though that [Chart, Chart Options, Data Labels] functions could solve my problem, but it didn't.

Any ideas?

Ivan F Moala · Mar 23rd, 2002, 06:19 AM

select data series = BLOCK
Right click
select Format data series
select Data lables / Show lables

Ivan

andy-s · Mar 24th, 2002, 05:46 AM

Thanks for your reply.

But your answer did not solve my problem though; the chart displayed the 2.2 value instead of the name AA.

There is one way around; I can edit the label manually.

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

Mar 23rd, 2002, 04:23 AM	#1
andy-s Board Regular Join Date: Mar 2002 Posts: 51	Column A consists of names like AA, BB, CC. Column B consist of values like 2.2, 3.4, 3.6 Column C also consist of values like .7, .6, .3 I've no problem with making an ordinary xy plott. BUT, instead of the traditional square markerstyle, I would like the name of xy value. (e.g AA for the 2.2 and .7 plott) I though that [Chart, Chart Options, Data Labels] functions could solve my problem, but it didn't. Any ideas?

Mar 23rd, 2002, 06:19 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	select data series = BLOCK Right click select Format data series select Data lables / Show lables Ivan

Mar 24th, 2002, 05:46 AM	#3
andy-s Board Regular Join Date: Mar 2002 Posts: 51	Thanks for your reply. But your answer did not solve my problem though; the chart displayed the 2.2 value instead of the name AA. There is one way around; I can edit the label manually.