Quadrant Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help me figure out how to take two data points and have it appear
as a single entry in a Quadrant Chart. EX: (X&Y-Axis are both on a scale of
1 to 10. An entry may have X axis value of 6 and Y axis value of 8. I would
like to have that represented as a single point in the upper right quadrant
of a chart respective to the intersection point of 6 & 8.)
 
When I choose the XY Chart, I get both data points on the chart?
Data=
X Y
One 6 8
Two 5 9
Three 4 3

I would like to see the Chart represent each item as a single data point at
the intersection of the values. EX: Item ONE would appear in the chart as a
single point at the intersection of 6 on the X axis and 8 on the Y axis.

Any additional insight/information you can provide would be greatly
appreciated.
 
When I choose the XY Chart, I get both data points on the chart?
Data=
X Y
One 6 8
Two 5 9
Three 4 3
Click to expand...


Select only the last two columns, and temporarily remove the "X" title
heading.

Data=

Y
6 8
5 9
4 3
 
Series name: One, X values, point it at the cell where your 6 is, Y values,
point it at the cell where your 8 is.
Series name: Two, X values, point it at the cell where your 5 is, Y values,
point it at the cell where your 9 is.
....
 
Back
Top