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