Combine three bar charts into one, with stacked bars..?

[ferlev]

Hi Everyone,

I got this problem, where I have answers from a questionnaire, and I have calculated results in percent. I would like to show them in a stacked bar chart.
In the attached file, I just made a example. I know the charts are two different types, but how do I combine them into one chart??

Any help would be appreciated.!

I already posted this question in another forum. Here you can also DL my example file..
https://www.excelforum.com/excel-ch...charts-into-one-stacked-bars.html#post5208874

Regards,
Flemming

 

[Anthony47]

Anthony47, thanks for your time and patience to understand my wish
Since the x-axis is percent it will do for them all.

I would just add legends to the bottom of your graf, and apply custom colours to each category to explain them.
(Is legends the right word? Or maybe its called series in excel?)
Could I see the workbook you made?

The updated file can be downloaded at the same link I published in message #5 , that is
https://www.dropbox.com/s/45f1yfw3k6mdb7g/byFERLEV-MR_Book1_B91011.xlsx?dl=0

Bye