E
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.
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.