How to merge 2 chart types

[camran]

Hello folks,

I have a simple clustered column graph. It has 3 columns taking data from 3 different rows. So what now i am trying to do is that there should be 2 columns with following arrangement

- The first column, taking data from its series, should remain same
- The second and third column should be merged so that they should appear as "Stacked Column" Graph.

I am making sense? I want the data series of 2 columns to be merged with first column as it is as "Clustered Column". it means merging 2 types of charts... is it possible????

[Andy Pope]

See previous post
http://www.excelforum.com/excel-char...bar-chart.html

[camran]

Thanks... but i am not looking for this.

I have 3 columns [of charts] coming from 3 different rows... right... So what i want is 1st column should remain as it is... and last two columns should become 1 column with changed colors indicating that this column has 2 different rows... I think i have made it clear now

[Andy Pope]

Did you check the link in the other thread?

I know the example has 2 clustered columns with 2 stacks but you can adapt the technique for your case 2 clustered columns with the 2nd column stacked.