I am running WinXP and Excel2000. I have several X,Y datasets that I would like to plot/chart. The X values are evenly spaced in all datasets. The X increment is exactly the same in all three. If the sets were concatenated, the resulting X's would still be spaced at the original X increment. For the case of 2 x,y pairs in each data set, the data might look like:

Set 1
1,1
2,4

Set 2
3,9
4,16

Set 3
5,25
6,36

Yes, in this example, it is simply Y = X^2

If I generate an XY scatter plot with each set as 3 separate series, I get a consistent curve over the range of X [1,6]. But if I generate a column chart with 3 separate series, Excel ignores the actual values of X and considers them labels; and effectively sets the X's to 1,2 for each set. Thus the data ends up looking like:
1,1
2,4
1,9
2,16
1,25
2,36

In fact, virtually every chart type in Excel except XYscatter, does the same thing to the X's.

So, how can I plot multiple sets (3 in this case) as "columns" and force Excel to pay attention to the X values?

Thanks