Basically I am looking as to how I would write the data into excel in order to make a pie of pie chart, no way I have tried has currently been successful.

I want the primary pie to be Yes = 32 and No = 11

Secondary pie I want to be a breakdown of Yes where:

U= 16
V = 8
W = 6
X = 3
Y =2
Z = 1

note: the totals of U, V, W, X, Y and Z are more than the 32 of yes as more than one option was allowed to be picked, im not sure if that is where the difficulty lies.

Any help would be greatly appreciated