Hello

Did you mean something like this?

http://www.andypope.info/charts/Invertneg.htm


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"nellis" wrote:

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?