Graphic for CashFlow Model

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.

B.
CF-Graphic-Sampler.xlsm
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SteveCommented:
OK, first bit is done.. plotting break even may be a tad harder :)
CF-Graphic-Sampler.xlsm
0
SteveCommented:
OK, for the second bit I have created a second graph...
a stacked bar chart
on it's side.
Scaled 0 to 36
Filled with no fill for all but a little bar.

This gives the desired result .

Is it OK?
CF-Graphic-Sampler.xlsm
0
Bright01Author Commented:
This looks great!  How do I change the colors on the bars?  

Thanks,

B.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

SteveCommented:
Well, the two graph method can be a tad funky...
As you have the BEP line plotted on a transparent graph on top of the other graph.
To work on the bottom "main" bar graph, you just move the transparent BEP out of the way.
Changing bar colurs is just as normal then...
(select bar and use fil on home ribon, or right click format)
Once happy with the bottom graph, move the transparent one back.

This method is a tad fiddly, but the only way I know of without going into VBA.
But VBA has a tendency to be more hastle at times than the over graph.

To help with ligning up the graphs, I tend to...
Highlight a grap, select format from the ribon.
Then on align, choose 'snap to grid'.
With snap to grid on, movements are in line with the excel sheet (as a grid) and so moves can be easier.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
I did figure it out.. I see what you did............. life is an illusion.  Much thanks!!!!!

B.
0
SteveCommented:
Indeed, all smoke and mirrors.
happy you got the result you wanted :)
ATB
Steve.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.