Stacked bar chart with Y axis values and data labels as %

[nsaray]

Hi

I want to plot the following in a stacked bar chart (USD BUY, Sell and Non USD) but want the Y axis to be $ and the data labels to be the percentages of the total. Is this possible?

TYPE	CCYY_MM	USD BUY	USD SELL	NON USD		% USD Buy	% USD Sell	% Non USD
Type 1	2018-07	25,433,171,832	26,007,534,928	5,465,037,778		45%	46%	10%
	2018-08	25,490,106,878	18,339,329,069	7,397,680,867		50%	36%	14%
	2018-09	26,357,963,060	15,342,844,028	6,436,374,013		55%	32%	13%
Type 2	2018-07	11,438,590,452	6,942,432,706	3,400,535,273		53%	32%	16%
	2018-08	10,657,977,063	5,922,456,964	4,242,688,476		51%	28%	20%
	2018-09	14,324,124,841	7,289,472,789	4,162,251,854		56%	28%	16%

[v-piga-msft]

Hi @nsaray,

I'm a little confused about your requirement.

Do you want the stacked bar chart like below?

Best  Regards,

Cherry

[nsaray]

Hi

I want to plot the following in a stacked bar chart (USD BUY, Sell and Non USD) but want the Y axis to be $ and the data labels to be the percentages of the total. Is this possible?

TYPE	CCYY_MM	USD BUY	USD SELL	NON USD		% USD Buy	% USD Sell	% Non USD
Type 1	2018-07	25,433,171,832	26,007,534,928	5,465,037,778		45%	46%	10%
	2018-08	25,490,106,878	18,339,329,069	7,397,680,867		50%	36%	14%
	2018-09	26,357,963,060	15,342,844,028	6,436,374,013		55%	32%	13%
Type 2	2018-07	11,438,590,452	6,942,432,706	3,400,535,273		53%	32%	16%
	2018-08	10,657,977,063	5,922,456,964	4,242,688,476		51%	28%	20%
	2018-09	14,324,124,841	7,289,472,789	4,162,251,854		56%	28%	16%

[Anonymous]

Hi @nsaray,

It is better to show  %Value in your tooltip. Because directly we can not achieve directly but in tricky way we can show this to user. We have to use two chart. 

For 1 chart just disable title and legend and keep both axis and in 2nd chart just off both axis then enable data level on 2nd chart as %Value.

Here i have created sample from your file. Please find the link.