software

How do I show a percentage in a bar chart?
A B C
D
quot;Store 1 Revquot; quot;% of Total Revquot; quot;Store 2 Revquot; quot;% of
Total Revquot;
1 Prod1 100 3% 100
3%
2 Prod2 90 2% 80
1%
3 Prod3 80 1% 90
2%

Say I have 50 stores. I just want the data for the bar chart to be the
Store Rev for the two stores and then on the chart show the quot;% of Total Revquot;
for each product on the bars.

Hi qwerty4546,

Are you sure you mean quot;Say I have 50 storesquot;?
I ask this because you later state quot;for the two storesquot;
Do you mean quot;Say I have 50 productsquot;?

Are you wanting a bar chart with two bars, one bar for each of the two
stores and each store's bar size representing its total revenue, and
then each of the two bars subdivided into fifty parts, 1 part for each
product's contribution to the total revenue?

Ken Johnson