View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
qwerty4546
 
Posts: n/a
Default Bar Chart Percentage

How do I show a percentage in a bar chart?
A B C
D
"Store 1 Rev" "% of Total Rev" "Store 2 Rev" "% of
Total Rev"
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 "% of Total Rev"
for each product on the bars.