I have a great little model that The_BarMan helped me build out. I'm now trying to put the graphic with it. It measures cashflow in a barchart and will adjust based on changing criteria (i.e. Benefits, Costs, Discount Rate, etc.). Here's what I'm looking for. How do I get it to project Red Bars if the numbers corresponding to the bars are negative and green if the numbers are positive? Also, how do I get a marker (right now I have a manual marker that I have to move every time things change (the Red Line) that "pinpoints" the Breakeven Point on the graph?
Hope you're up for the challenge!
Thank you, in advance.