Text on Axis for Stacked Bar Chart

[Anonymous]

Hi

I'm creating a stacked bar chart. I'm wondering if it's possible to show the total value of the bar  (Total Qty by Sales Rep) at the axis or the end of the bar, while inside the bar, display percentage for each item?

From what I got so far, the value on axis isn't the total value but the item value instead. See the circled below in red.

This is my data.

Sales Rep	Item	Qty	Total Qty by Sales Rep
James	Apple	2	38
James	Pear	14	38
James	Banana	21	38
James	Orange	1	38
Allen	Pear	35	62
Allen	Banana	2	62
Allen	Orange	25	62
Tom	Apple	15	80
Tom	Pear	25	80
Tom	Banana	15	80
Tom	Orange	25	80

Thanks

Yvonne

[rwunderlich]

It's possibile in SR11 to show a Total for the entire stack on top of the bar, in addition to within each bar.

-Rob