Hi,

I have two sets of data which are located in different sheets,
and want to create the line chart which will show the graphics as
followings,
1. A B
1.5 2001
2 2003
2.3 2004
2.3 2005

2. A B
2.3 2000
2.1 2004
3.1 2005
3.2 2007

I am trying to use the secondary x aixs and two series but in x aixs it
only show either 1 or 2 data
How to figure out this problems or anyway to go?

Thanks,
Robert

have you gone to <Chart><chart options> <axis> and selected secondary x axis?

"rob" wrote:

> Hi,
>
> I have two sets of data which are located in different sheets,
> and want to create the line chart which will show the graphics as
> followings,
> 1. A B
> 1.5 2001
> 2 2003
> 2.3 2004
> 2.3 2005
>
> 2. A B
> 2.3 2000
> 2.1 2004
> 3.1 2005
> 3.2 2007
>
> I am trying to use the secondary x aixs and two series but in x aixs it
> only show either 1 or 2 data
> How to figure out this problems or anyway to go?
>
> Thanks,
> Robert
>
>

[1] Which is X and which is Y? Normally years would be an X value, in
which case they should be in the column to the left of the Y values.
It's not an absolute rule of course, but a good practice to get into.

[2] Have you tried an XY chart instead of a Line chart? You can apply
the same series formatting (markers and connecting lines) in both types
of chart, but the XY chart actually treats the X values as numerical values.

[3] Do you really need secondary axes?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


rob wrote:

> Hi,
>
> I have two sets of data which are located in different sheets,
> and want to create the line chart which will show the graphics as
> followings,
> 1. A B
> 1.5 2001
> 2 2003
> 2.3 2004
> 2.3 2005
>
> 2. A B
> 2.3 2000
> 2.1 2004
> 3.1 2005
> 3.2 2007
>
> I am trying to use the secondary x aixs and two series but in x aixs it
> only show either 1 or 2 data
> How to figure out this problems or anyway to go?
>
> Thanks,
> Robert
>