#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.)
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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.)



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.)




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default 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.
  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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.)








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quadrant Chart Sample [email protected] Charts and Charting in Excel 2 September 28th 06 02:54 AM
Four Quadrant Bubble Chart in Excel? [email protected] Charts and Charting in Excel 7 September 20th 06 05:49 PM
how can I make a quadrant analysis chart using excel sean Charts and Charting in Excel 1 September 19th 05 01:30 PM
Does anyone have a template or spreadsheet with a Quadrant Chart? MovingOn Charts and Charting in Excel 2 March 20th 05 01:25 AM
how do I create a quadrant chart in Excel or PowerPoint? Tavo Charts and Charting in Excel 1 March 11th 05 12:11 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"