LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Per
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 05:08 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"