Waterfall chart

Hello
I have a waterfall chart showing:

Budget 20xx
Variance type 1
Variance type 2
Variance type 3
Variance type 4
Variance type 5
=Revised budget 20xx

In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for example
that type 1 and 2 are negative while type 3, 4 and 5 are positive.

Question:
Is it possible to have bars showing negative variances in one color and positive variances in another?

Hans Knudsen

I know I can do it manually, but is it possible to do it automatically?

Hans Knudsen


"Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> skrev i en meddelelse news:ubU2LOZsDHA.2348@TK2MSFTNGP09.phx.gbl...
> Hello
> I have a waterfall chart showing:
>
> Budget 20xx
> Variance type 1
> Variance type 2
> Variance type 3
> Variance type 4
> Variance type 5
> =Revised budget 20xx
>
> In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for
example
> that type 1 and 2 are negative while type 3, 4 and 5 are positive.
>
> Question:
> Is it possible to have bars showing negative variances in one color and positive variances in another?
>
> Hans Knudsen
>
>

See the Excel | Charts | Waterfall Chart page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <ubU2LOZsDHA.2348@TK2MSFTNGP09.phx.gbl>,
hans.knudsen__REMOVE__@mail.tele.dk says...
> Hello
> I have a waterfall chart showing:
>
> Budget 20xx
> Variance type 1
> Variance type 2
> Variance type 3
> Variance type 4
> Variance type 5
> =Revised budget 20xx
>
> In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for example
> that type 1 and 2 are negative while type 3, 4 and 5 are positive.
>
> Question:
> Is it possible to have bars showing negative variances in one color and positive variances in another?
>
> Hans Knudsen
>
>
>

Thank you.

Hans Knudsen


"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> skrev i en meddelelse
news:MPG.1a2a6f5c695c73a698ad81@msnews.microsoft.com...
> See the Excel | Charts | Waterfall Chart page of my web site.
>
> --
> Regards,
>
> Tushar Mehta, MS MVP -- Excel
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <ubU2LOZsDHA.2348@TK2MSFTNGP09.phx.gbl>,
> hans.knudsen__REMOVE__@mail.tele.dk says...
> > Hello
> > I have a waterfall chart showing:
> >
> > Budget 20xx
> > Variance type 1
> > Variance type 2
> > Variance type 3
> > Variance type 4
> > Variance type 5
> > =Revised budget 20xx
> >
> > In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for
example
> > that type 1 and 2 are negative while type 3, 4 and 5 are positive.
> >
> > Question:
> > Is it possible to have bars showing negative variances in one color and positive variances in another?
> >
> > Hans Knudsen
> >
> >
> >

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <#uP3VLfsDHA.1088@tk2msftngp13.phx.gbl>,
hans.knudsen__REMOVE__@mail.tele.dk says...
> Thank you.
>
> Hans Knudsen
>
>
> "Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> skrev i en meddelelse
> news:MPG.1a2a6f5c695c73a698ad81@msnews.microsoft.com...
> > See the Excel | Charts | Waterfall Chart page of my web site.
> >
> > --
> > Regards,
> >
> > Tushar Mehta, MS MVP -- Excel
> > www.tushar-mehta.com
> > Excel, PowerPoint, and VBA add-ins, tutorials
> > Custom MS Office productivity solutions
> >
> > In article <ubU2LOZsDHA.2348@TK2MSFTNGP09.phx.gbl>,
> > hans.knudsen__REMOVE__@mail.tele.dk says...
> > > Hello
> > > I have a waterfall chart showing:
> > >
> > > Budget 20xx
> > > Variance type 1
> > > Variance type 2
> > > Variance type 3
> > > Variance type 4
> > > Variance type 5
> > > =Revised budget 20xx
> > >
> > > In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for
> example
> > > that type 1 and 2 are negative while type 3, 4 and 5 are positive.
> > >
> > > Question:
> > > Is it possible to have bars showing negative variances in one color and positive variances in another?
> > >
> > > Hans Knudsen
> > >
> > >
> > >
>
>
>

Hans -

The waterfall chart example on my web site:

http://www.geocities.com/jonpeltier.../Waterfall.html

allows for different formatting for positive and negative variances.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Hans Knudsen wrote:

> I know I can do it manually, but is it possible to do it automatically?
>
> Hans Knudsen
>
>
> "Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> skrev i en meddelelse news:ubU2LOZsDHA.2348@TK2MSFTNGP09.phx.gbl...
>
>>Hello
>>I have a waterfall chart showing:
>>
>>Budget 20xx
>>Variance type 1
>>Variance type 2
>>Variance type 3
>>Variance type 4
>>Variance type 5
>>=Revised budget 20xx
>>
>>In one month variance type 1, 2 and 3 may be negative and type 4 and 5 positive. In another month this may be different, for
>
> example
>
>>that type 1 and 2 are negative while type 3, 4 and 5 are positive.
>>
>>Question:
>>Is it possible to have bars showing negative variances in one color and positive variances in another?
>>
>>Hans Knudsen
>>
>>
>
>
>