• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charts and Drop Down Boxes

R

Rodrigo

New Member
Hi, I have four input scenarios from a drop down box, each one will result in different values to the "Profit After Tax" bottom line. I would like to present these results on a graph without resorting to "paste special - values". Is there another way of storing output values for the four scenarios.


Regards


Rodrigo
 
Rodrigo


You can use the Data Tables function to run and store results as you have suggested


have a read of the Data Table parts of


http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/
 
You must log in or register to reply here.
Back
Top