Waterfall chart

[Hans Knudsen]

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 Knudsen]

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

Hans Knudsen

 

[Tushar Mehta]

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

 

[Hans Knudsen]

Thank you.

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

 

[Tushar Mehta]

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

 

[Jon Peltier]

Hans -

The waterfall chart example on my web site:

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

allows for different formatting for positive and negative variances.

- Jon