Thanks for the response, Jon. I did think of a waterfall chart, however I
have 7 ship points that I want to show variances for and was hoping to do
this in one chart - each bar would be a ship point and broken down by
variance components.
"Jon Peltier" wrote:
Instead of a stacked bar chart, try a waterfall chart:
http://peltiertech.com/Excel/Charts/Waterfall.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"nellis" wrote in message
...
I'm trying to graph the components of a year-over-year variance (example,
fuel, new store growth, realigment of stores, etc.), along with the total
variance, but one of the components is negative. If I just take the
individual variances and graph in a bar chart, the size of the bar chart
is
greater than the total because it's not factoring in the negative
component.
How can I do this?