To combine two chart into one..

[cs168]

Hi all
Is it possible to combine two chart into one chart in excel, What I mean is if I have below data:-
WW-----A-----------B
01-------400-------80
02-------550-------75
03------680--------125
04------475--------95

currently I have two chart showing the data, what I want is to have two chart into one which content
Y axis start from 300 to 800
another y axis start from 0 to 250
and only one X axis which is my ww...

Pls comment and help on this tks...

[RobDog888]

You mean like this? There is no way to create 2 Y axis but you can do like I did and have them combined in a single Y axis.

[cs168]

Tks for the help. I am looking for a line chart that consist two Y axis line & there is a seperator in between to seperate it....

[RobDog888]

You would have to create two separate charts. Cant do it in just one.

[JustinLabenne]

You could plot each series on 2 seperate axis (not the way you want):


And even though this website doesn't show you how to do what your asking (may not be possible) it has some pretty nifty charts that can maybe be an alternative for you: http://www.andypope.info/charts.htm