X-axis scale problem

[jazzbone88]

I am attempting to plot two sets of data (x1,Y1) and (x2,y2) on a
combined scatter chart. BUT (x1,y1) data is not in the correct
orientation I need to present it so I have to reverse the x scale so
that it read from right to left . . .4, 3,2,1,0 so zero is at the far
right end of the data chart. I got this part, but I need to put the
second set of data (x2,y2) on this very same chart but it needs to
start from the modified x axis on zero and count up i.e 0, 1, 2, 3,
ect. so my x axis should look like this when finished 3, 2, 1, 0, 1, 2,
3 etc... I think my problem is that you can only plot one set of data
at a time on an XY plot does anyone know a way around this? My data
should look something like a broad "S" curve when this two data sets
are combined. Any help would be appreciated

 

[Jon Peltier]

Bones -

You have apparently created a Line chart. A line chart simply uses the X
values as labels in a category-type axis, in the order the sheet stores
them, without regard to any numerical value. And every series in a line
chart uses the same X values.

You need to create an XY Scatter chart, or change the existing chart.
Select the chart, choose Chart Type from the Chart menu, and choose from
the XY Scatter choices (fifth icon down the left hand list), not the
Line chart choices (third icon down).

Still confused? You're in good company; Microsoft has probably not
documented the differences clearly enough. Here's some additional
information:

X Axis: Category or Value?
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

- Jon