How to Chart XXY axis with different X axises

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Jon, this is very helpful. You are the master of excel chart. Thank you for
your help.

luvgreen
 
Back
Top