Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |