I've created what I call a waterfall chart, a bar chart moving from budget to actual with the explaning variances moving up or down depending on the given periods results. a bunch of nested if statement pick out the color red for negative and blue for positive. but the labels appear inside the bar. How do I get the label either just above or just below the bar? Preferably just above with positive results and just below with negative...

so the data looks likt this:
Target Income Expense Income Result
Bgt GP OP Exp Non-Op Actual

pretax NI Before Alloc 3,939 3,759
New Base 3,604 3,604 3,656
positive var Above - 52 102
Pos Var Below - - -
Neg Var Above 334 - -
Neg Var Below - - -
ending base 3,939 3,604 3,656 3,759 3,759

I have been moving the labels around manually for years and wondered how I might automate this?

Thank You for your consideration!
Cheers
grasstoe