To combine two chart into one..

cs168 · #1 09-10-2005, 12:10 PM

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...

#2 09-11-2005, 09:05 AM

You should be able to find what you need for a combo chart on Jon Peltier's
site

http://www.peltiertech.com/Excel/Cha...mboCharts.html

"cs168" <cs168.1v5hqa_1126368320.6439@excelforum-nospam.com> wrote in
message news:cs168.1v5hqa_1126368320.6439@excelforum-nospam.com...
>
> 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...
>
>
> --
> cs168
> ------------------------------------------------------------------------
> cs168's Profile:
> http://www.excelforum.com/member.php...o&userid=27116
> View this thread: http://www.excelforum.com/showthread...hreadid=466521
>

#3 09-11-2005, 12:05 PM

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

In article <cs168.1v5hqa_1126368320.6439@excelforum-nospam.com>,
cs168.1v5hqa_1126368320.6439@excelforum-nospam.com says...
>
> 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...
>
>
> --
> cs168
> ------------------------------------------------------------------------
> cs168's Profile: http://www.excelforum.com/member.php...o&userid=27116
> View this thread: http://www.excelforum.com/showthread...hreadid=466521
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)