Quadrant Chart
 

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

Quadrant Chart
 

Use an XY chart.
--
David Biddulph

"Nullifier" wrote in message
...
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.)

Quadrant Chart
 

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.

"David Biddulph" wrote:

Use an XY chart.
--
David Biddulph

"Nullifier" wrote in message
...
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.)

Quadrant Chart
 

On Wed, 20 Jun 2007, in microsoft.public.excel.charting,
Nullifier said:

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


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

Data=

Y
6 8
5 9
4 3

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Quadrant Chart
 

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.
....
--
David Biddulph

"Nullifier" wrote in message
...
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.

"David Biddulph" wrote:

Use an XY chart.
--
David Biddulph

"Nullifier" wrote in message
...
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.)