Hello everyone, I'm having some trouble with a chart I put together. The lines are fine, but the columns are whack.
- The green bars (forecasted upside effect) should start at 0 and have no area fill.
- The red bars (forecasted downside effect) should start at 0 and be inverted (they are all negative values) with no area fill.
- The black bars (change in revenue) should start at 0 and fill in the areas of the forecasted upside or downside, whichever applies, so inverted if negative.
- All 3 should be on the same "axis". Here's what I mean: http://img403.imageshack.us/img403/4176/chartx.jpg
I'm sure this is a simple issue, but I'm an excel scrub despite my enjoyment for playing with numbers so it would be cool to learn how to do this. Thanks in advance if anyone can help!
A side question that I don't know the answer to:
It would be nice to have a dashed vertical line to distinguish between the past and forecasted numbers.
Here is the chart! : http://www.megaupload.com/?d=Q4EGPF1L
Bookmarks