Creating an investment planner, input values into a chart, output new value into column

[Neil_Haque]

Hi there, I am trying to create an investment portfolio planner and so far this is what I have…

What I’m hoping to do is be able to plug in an initial investment number, for example plug $5000 in somewhere, then that is charted in the pie graph, and also the dollar amount of each stock is output in a column. So the formula would be:
($50000.25) = Stock 1 weight
($50000.20) = Stock 2 weight
But of obviously the initial investment value can be edited/changed

Thanks for any input!

[Shaheed_Fazal]

Try creating a control above your chart that stores the value of the initial amount. Then you can use that in a formula for the amount column.