Excel 2013 - Chart Type - Stacked & Clustered

Hi Guys,

Having trouble with a task.
I want to have a chart that incorporates both a stacked and clustered column.

For Eg; I want the total figure for No to be in a single column, and the figures from Yes and Mayb in to a stacked column.

Red Purpl Blue Yel Oran Gree Black
No 30.6 8.9 119 9.5 31.1 0 5.2
Yes 0 0 0 80 99 80 0
Mayb 76 8 141 13 8 0 0


Can anyone help?

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.