Question about how to show subtotal percentage in Stacked column chart

[Anonymous]

Hi everyone~

i have a data sample is like:

ID	Type	Detail
1	A	1
1	A	2
1	A	2
1	A	2
1	A	2
1	B	1
1	B	1
1	B	1
1	B	1
1	B	1
1	B	2
1	B	1
1	B	2
1	B	2
1	B	2
1	B	1
1	C	1
1	C	1
1	C	2
1	C	2

i wanna use the Stacked column chart  to show the data:

i want the data lable showing the percnetage of each type, not for the grand total. how can i do that?

thanks!

[Anonymous · Accepted solution]

You must use the "100% stacked column chart"

[Anonymous]

I am concerning that if i use it, i will lost the overall analysis, because the count of each items is also important.