|  | Chart with X Values | | |
| | | faceman28208@yahoo.com |  |
|  Posted: Sun Jun 01, 2008 6:41 am Post subject: Chart with X Values |  |
I have a number of data pairs that I would like to graph in a line
chart. They are in (X,Y) format. I would like to get a chart (e.g.
line chart) of these values such that each Y value is plotted at the X
value.
Every combination I have tried plots the pairs evenly spaced in the
order they occur in the data sheet with the X values apparently only
serving as labels.
In other works, if I have
1 1
3 3
2 2
5 5
I would like to get a chart showing a straight line.
How would I go about doing this? |
| |
| | | Andy Pope | |
| | Posted: Sun Jun 01, 2008 6:41 am Post subject: Re: Chart with X Values | |
Hi,
The Line chart uses a Categorical axis, except when doing Time series.
Instead use the XY-Scatter chart type. This plots both points as
numerical values.
Cheers
Andy
faceman28208@yahoo.com wrote:
| Quote: | I have a number of data pairs that I would like to graph in a line
chart. They are in (X,Y) format. I would like to get a chart (e.g.
line chart) of these values such that each Y value is plotted at the X
value.
Every combination I have tried plots the pairs evenly spaced in the
order they occur in the data sheet with the X values apparently only
serving as labels.
In other works, if I have
1 1
3 3
2 2
5 5
I would like to get a chart showing a straight line.
How would I go about doing this?
|
--
Andy Pope, Microsoft MVP - Excel
LINK |
| |
| | | Bruce Sinclair | |
| | Posted: Tue Jun 03, 2008 2:49 am Post subject: Re: Chart with X Values | |
In article <#gNbaL8wIHA.5124@TK2MSFTNGP04.phx.gbl>, Andy Pope <andy@andypope.info> wrote:
| Quote: | Hi,
The Line chart uses a Categorical axis, except when doing Time series.
Instead use the XY-Scatter chart type. This plots both points as
numerical values.
|
... and IIRC, scatterplot is the *only* chart type that allows variable x
axis differences ! This is (or certainly was) a serious trap for young
players. :)
| Quote: | faceman28208@yahoo.com wrote:
I have a number of data pairs that I would like to graph in a line
chart. They are in (X,Y) format. I would like to get a chart (e.g.
line chart) of these values such that each Y value is plotted at the X
value.
Every combination I have tried plots the pairs evenly spaced in the
order they occur in the data sheet with the X values apparently only
serving as labels.
In other works, if I have
1 1
3 3
2 2
5 5
I would like to get a chart showing a straight line.
How would I go about doing this?
|
|
| |
|
|
