View Single Post
  #1   Report Post  
rob
 
Posts: n/a
Default anyway to go with excel two sets of data

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