Waterfall chart

  • Thread starter Thread starter Hans Knudsen
  • Start date Start date
H

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
 
I know I can do it manually, but is it possible to do it automatically?

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
 
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
 
Back
Top