# graph variance components when 1 is negative

nellis
Guest
Posts: n/a

 29th Jul 2008
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?

Wigi
Guest
Posts: n/a

 29th Jul 2008
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?

Jon Peltier
Guest
Posts: n/a

 29th Jul 2008
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" <(E-Mail Removed)> wrote in message
news:86A3E2FD-758D-4195-8DD9-(E-Mail Removed)...
> 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?

nellis
Guest
Posts: n/a

 30th Jul 2008
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" <(E-Mail Removed)> wrote in message
> news:86A3E2FD-758D-4195-8DD9-(E-Mail Removed)...
> > 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?

>
>
>

Jon Peltier
Guest
Posts: n/a

 30th Jul 2008
A stacked chart isn't exactly what you want. You could set it up so there
are two stacks per item, one positive and one negative. This would work
fine, but it would take some rearranging of the data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"nellis" <(E-Mail Removed)> wrote in message
news:85C28220-1429-4239-A19D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:86A3E2FD-758D-4195-8DD9-(E-Mail Removed)...
>> > 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?

>>
>>
>>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post seadog471 Microsoft Excel Misc 3 20th Mar 2009 06:07 PM sauza311 Microsoft Excel Charting 3 16th Jan 2008 08:19 PM =?Utf-8?B?UEpT?= Microsoft Excel Misc 2 18th Jan 2006 04:12 AM =?Utf-8?B?Q3JhaWdT?= Microsoft Excel Misc 5 6th Jan 2005 01:22 AM Microsoft Microsoft Dot NET Framework 2 20th Feb 2004 08:42 PM

Features