Forum Discussion
100% stacked bar chart format
In fact showing the value makes a lot of sense because it allows another measure to be described within a single chart... a 100% stacked chart should allow you to quickly sense changes in composition (for example, sales by product line) over whatever is the X axis, but as you already said, it tells you nothing about the volume (or importance of those changes)
As it is now you could easily see that - let's say - Fruit sales went from 25% to 50% from Jan to Feb but... was that because you sold more Fruits? or because you sold less of the other products? is it truly relevant because in Feb you sell the same or a lot more than in Jan? or it is neglible because that particular Feb you almost did no sale at all?
See all those question could be answered with a 100% stacked chart that *also* allowed you to display a value but can't be answered as it is now
Makes sense?
jcr1968es I can feel you have experienced the same pain i did when needing both % & values in the 100% stacked chart.
The 2 values complement each other and help consumers avoid any negligible value differnces that can have large % variances.
Think doubling sales from 1 USD to 2 USD = 100% in an emerging market and comparing that to your mature market which goes from 1 Million USD to 1.1 Million USD = 10%. I know i'd want to draw attention to the 10% irrespective of the 100% emerging market's success.
David