Scatter Graph

[Erin]

Hello All,

I'm working with a table like this
A B C
1 Quantity Quality
2 Vendor 1 4.3 2.3
3 Vendor 2 5.2 4.1
4 Vendor 3 6.1 5.3
5 Vendor 4 4.1 1.2

I would like a scatter graph with the quantity numbers
along the x-axis and the quality numbers along the y-
axis. I've been able to get it to plot properly, but when
I click Show Label in the Format Data Series dialog box it
shows the x values.

I've tried setting it up the source data so that

Name = $A$3:$A$10
x values = $B$3:$B$10
y values = $C$3:$C$10

or setting up 4 different series with

Name = $A$3
x values = $B$3
y values = $C$3

and so on for each vendor.

Can someone tell me the proper way to set this up so that
Excel recognizes the Vendor names as the Label for each
point? I'd appreciate any help. Thanks.

 

[Debra Dalgleish]

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/Labeler.asp

 

[Erin]

Thanks. I'll give it a try.

-----Original Message-----
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/Labeler.asp



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

.