How to Chart XXY axis with different X axises

[Guest]

Hello all,

I have been searching around the forum to see if I can find an answer to
create a XXY chart. I found one answer but it was not working for my case.
Please help.

X(1) will be in top, X(2) bottom. Plot Y1 and Y2. Thanks much!


X axis(1) X axis(2) Y(1) Y(2)
Jan-06 1/1/06 3 0
Feb-06 1/1/06 5 0
Mar-06 3/5/06 0 0
Apr-06 3/6/06 1 0

 

[Jon Peltier]

Every series needs X values and Y values. Select the X and Y data for one
series and make your chart. Copy the X and Y data, select the chart, use
Paste Special from the Edit menu to add the data as a new series, with
category (X) values in the first column. Double click one series, and on the
Axis tab, select Secondary. Go to Chart Options on the Chart menu, and on
the Axes tab, check and uncheck boxes until the combination of axes you need
is checked.

- Jon

 

[Guest]

Jon, this is very helpful. You are the master of excel chart. Thank you for
your help.

luvgreen