To combine two chart into one..

  • Thread starter Thread starter cs168
  • Start date Start date
C

cs168

Hi all
Is it possible to combine two chart into one chart in excel, What
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 tw
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..
 
Create a chart with the first set of data. Next, select the B column
data and copy. Select the chart and paste. XL will pop up with a
dialog box about how to treat this new data. Ensure you select 'New
series.'

In the chart, right-click one of the plotted series and select Format
Data Series... | Axis tab. Check on 'Secondary axis'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top