100% Stacked column chart

[#1]

Hi,

Does anyone know how to create a '100% stacked column' chart in a way, that tool compares the % not to the total, but to the reported groups? I.e.: sum(Product "X")=100%

	Product "X"	Product "Y"	Product "Z"	Grand Total
Approved	1,427,075	267,717	1,189,907	2,884,699
Rejected	847,693	765,022	817,593	2,430,308

And is it possible in any way to have both, the values and the % visible in the same chart? Or at least add the values into a % bar chart? Many thanks for your help!