Switching axis of a chart

[pgflrob]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I want to switch the x and y axis of a simple line chart.

 

[pgflrob]

Let me add more info in hopes that there is someone that can help me.

I have two data series in columns.
Series one is
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

Series two is
1,4,9,16,25,36,49,64,81,100,100,81,64,49,36,25,16,9,4,1

I am trying to draw a line graph that puts series one on the y axis and series two on the x.

 

[Mike Middleton]

pgflrob -

I cannot imagine what you mean by "series one on the y axis and series two
on the x."

But, in case your data are actually paired, i.e., (1,1), (4,2), (9,3), ...,
(1,20), then perhaps an XY (Scatter) chart type with lines between markers
is appropriate. If so, arrange your data with the X data in a column on the
left and the Y data in an adjacent column on the right; select all data (two
adjacent columns by twenty rows); insert the appropriate XY (Scatter) chart
type.

If that's not what you want, please explain with more details.

- Mike
http://www.MikeMiddleton.com



Let me add more info in hopes that there is someone that can help me.

I have two data series in columns.
Series one is
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

Series two is
1,4,9,16,25,36,49,64,81,100,100,81,64,49,36,25,16,9,4,1

I am trying to draw a line graph that puts series one on the y axis and
series two on the x.

 

[pgflrob]

Mr. Middleton, Thank you for taking the time to reply.

Let me try to use words to draw a picture. I want the line plot to look like a bulge out and back in from the y (vertical axis). No matter what I try, the line chart forces the monotonically increasing series on the x (horizontal axis) which of course produces a "mountain".

Yes the scatter charts works. I just have to have select the rows in the correct order when I select the data series(s). The first row becomes the x axis. There is a bar chart (sideways) that works (allows a bulge out). Interesting. But not a line chart. I know I am really not understanding something here pretty fundamental to line charts. But thanks this is a good work around.

I need to see when I have more series to plot if the scatter chart keeps working.

BTW, Each data series, the monotonically increasing series from 1...20, and the series which goes from 1 to 100 and back to 1 are in separate columns (i.e. a2:a21 and b2:b21.

 

[Mike Middleton]

pgflrob -

I know I am really not understanding something here pretty fundamental to
line charts. <

The Line chart type uses X data strictly as equally-spaced text labels on
the horizontal axis. The "values" of the X data are _not_ used to locate the
points.

The XY (Scatter) chart type makes use of the numerical data for both axes to
locate the points.

Either type of chart may be formatted to display or to not display lines
connecting the points.

- Mike
http://www.MikeMiddleton.com




Mr. Middleton, Thank you for taking the time to reply.

Let me try to use words to draw a picture. I want the line plot to look like
a bulge out and back in from the y (vertical axis). No matter what I try,
the line chart forces the monotonically increasing series on the x
(horizontal axis) which of course produces a "mountain".

Yes the scatter charts works. I just have to have select the rows in the
correct order when I select the data series(s). The first row becomes the x
axis. There is a bar chart (sideways) that works (allows a bulge out).
Interesting. But not a line chart. I know I am really not understanding
something here pretty fundamental to line charts. But thanks this is a good
work around.

I need to see when I have more series to plot if the scatter chart keeps
working.

BTW, Each data series, the monotonically increasing series from 1...20, and
the series which goes from 1 to 100 and back to 1 are in separate columns
(i.e. a2:a21 and b2:b21.