Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Chart Percentage
Hi qwerty4546,
Are you sure you mean "Say I have 50 stores"? I ask this because you later state "for the two stores" Do you mean "Say I have 50 products"? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i enlarge a pie chart by a fixed percentage? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |