Tricky graph
Hi,
I'm working on a graph that would show the differences (pos or neg) per
category (f. ex. Milk, juice, Eggs, Bread) between an actual result and a
forecast.
AR 2004 FC 2008
Milk 500 300
Juice 700 900
Eggs 50
Bread 200 100
Others 75
Total 1400 1475
The way I would like to present it is a stacked bar chart, where the lower
part of the bar is hidden (except first and last bar), so you only see the
differences, presented as the top bar. So;
First bar shows total 2004 (1400)
Second bar shows (1200 which is hidden) and 200 as a decrease in Milk
Third bar shows (1200 which is hidden) and 200 as increase in Juice
Fourth bar shows (1400 which is hidden) and 50 as increase in Eggs
Fifth bar shows (1450 which is hidden) and 100 as decrease in Bread
6th bar shows (1350 which is hidden) and 75 as increase in Others
7th bar shows 1425 as total forecat for 2008
(Would be easier if I could attach the spreadsheet...) Someone who has a
nice solution, would like to avoid scripts, due to company policies!
Cheers
|