Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quadrant Chart Sample | Charts and Charting in Excel | |||
Four Quadrant Bubble Chart in Excel? | Charts and Charting in Excel | |||
how can I make a quadrant analysis chart using excel | Charts and Charting in Excel | |||
Does anyone have a template or spreadsheet with a Quadrant Chart? | Charts and Charting in Excel | |||
how do I create a quadrant chart in Excel or PowerPoint? | Charts and Charting in Excel |