Thread: How to Chart XXY axis with different X axises

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"luvgreen" <luvgreen@discussions.microsoft.com> wrote in message
news:BA6F0B9D-7FCA-4068-AAB1-52E34F75A3E9@microsoft.com...
> 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, this is very helpful. You are the master of excel chart. Thank you for
your help.

luvgreen

"Jon Peltier" wrote:

> 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 Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "luvgreen" <luvgreen@discussions.microsoft.com> wrote in message
> news:BA6F0B9D-7FCA-4068-AAB1-52E34F75A3E9@microsoft.com...
> > 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
>
>
>