Thread: 2 sets of values on x-axis

Hi everyone,

I'm trying to do what seems to be a simple graph but i can't get it right!

I have the following data:

Col A Col B Col C
1.3 0.01 -0.01

1.27 0.01 0.01

1.25 0.01 0.03

1.23 0.01 0.05

1.2 0.01 0.07

I need to get Col A as the y-axis and plot ColB and Col C on the x-axis using line graphs

The closest i got to is as the chart below, but i need the axis to be inverted, like turning the whole graph 90degrees clockwise.

any help pls?
Thanks

Are you really using a Line graph, where the X values are treated as categories, or are you using an XY scatter plot that treats the X values as numeric?
If this is an XY plot, it's easy enough to plot two data series: one using B as the X data and A as the Y data, and two using C as the X data and A as the Y data. The easiest way I've found to acheive this (where the X values are to the right of the Y values) is to add the series using the Chart->Source Data dialog. Here you can individually pick the Y and X ranges for each series.

If you are need a line graph (category X axis), then someone else may have to help. I never use line graphs (or other graphs with a category X axis).

Thanks a lot....i did it as XY scatter and it worked.....

Thanks for the quick help!