EE Pros,

I have a nice graphic that has two conditions. The first condition is based on a "view" of benefits received - Conservative, Realistic, Aggressive. The second condition has to do with the % of benefit applied during a particular year (for 3 years) and a "Total". I've got the first condition down, but adding the second condition has complicated my graphic. I'm trying to use Indexing instead of "if" statements for the calculations.

The business application is rather simple. By pressing the two buttons, I should be able to view any year at any condition and at the end a total based on the condition choosen. See example for clear explanation.

Thank you in advance.

B.

Complex-dynamic-graphic-v2.xlsm
Perhaps, in addition to explaining your idea, please tell me where my approach is wrong:-

I think that for any given year a conservative approach should give a result different from an aggressive one. Therefore you need a table with years, say, on the X axis and Con/Real/Agg on the Y axis. If you would have such a table you could place the 20% benefit in the first year in relation to the Condition (risk-taking preference).

In short, if you wish to let your graphic display the effect of both Condition and Year it would be your table's duty to establish a relationshop between the two. This isn't the case, and therefore you have difficulty. To resolve the problem establish the relationship.