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?