Thread: Stacked columns percentages

Please reference the attached file.

Basically, the chart shows sales of products A, B, and C by region.

The chart represents how total sales of the regions compared to the other regions (by the height of the bar), and the percentages inside the bar show the percentage of the product compared to all the products (for ex. 9.1% is (product A / total of all products) or ( 300 / 3280))

My question is, is there any way to show the percentage of the product in a region, and still keep the same height? In other words, is there any way to get 42.9% (which is 300 / 700), 14.3%, and 42.9% to replace 9.1%, 3.0%, and 9.1%; 64.5%, 24.2%, 11.3% to replace 12.2%, 4.6%, 2.1%, etc. WHILE keeping the bars the same height as they are right now (thus still representing how the regions did compared with each other)?

Sorry, its a bit confusing. Please let me know how I can further clarify this if need be.

Thanks.