Forum Discussion
Multiple scenarios in one graph (using Scenario Manager)
I have a simple question but cannot seem to find the answer (unless it is "no").
How can I show multiple scenarios (what-if, using the Scenario Manager) in one and the same graph?
I know how to show scenario 1, and then scenario 2 (using the scenario manager), but how can I show both scenarios at the same time in one graph? Impossible?
One more scenario is with dynamic arrays
where
years: =TRANSPOSE(tData[[#All],[Year]]) scens: =TRANSPOSE(INDEX(tVar[#Headers],1,SEQUENCE(,COLUMNS(tVar)-1,2))) data: =TRANSPOSE(tData[Value])* TRANSPOSE(INDEX(tVar,1,SEQUENCE(,COLUMNS(tVar)-1,2))/ INDEX(tVar,2,SEQUENCE(,COLUMNS(tVar)-1,2) ) )
18 Replies
Hi, sorry for the delay (I got sidetracked) and thanks for looking into my question!
Attached a workbook with a simple example explaining what I want.
Below a screenshot.
In the upper part, I have a simple table, where one column depends on the variable Var. I have two scenarios, and the graph changes when I display another scenario, but I can't show the two scenarios at once.
In the lower part, I copied the values from scenario 1 and 2 into a new table, and I can of course show these 2 results in one graph. But these are unlinked from my scenario.
So what I would like is to have the lower double bar chart, but still dynamically linked to my scenarios.
Well, your example does make clear what you want. Unfortunately, that was never my question.
The question was how to get there from whatever it is that produces those two scenarios in the first place. Where are your scenarios calculated in the first place.
THAT's what we need to see. You have some data, somewhere, that shows conditions X, Y and Z, modified by percentage P over time T. Scenario one uses certain assumptions for P and T; Scenario 2, other assumptions for P and T. What I was asking was to see that arrangement of the "raw data" that underlies the graph(s)
How do you get two "What-ifs" into one graph. To answer that involves some kind of modification to the way you've set up the scenario in the first place. So we need to go back to that request, to see how your actual data are arrayed.
Short of seeing your original sheet, I can only offer general ideas, like having a separate column for Scenario 2 that bases its numbers on the same conditions as in Scenario 1, but changes one (or more) of the variables. That seems, in some ways, so obvious that I have to assume your situation has something in it that makes it more complicated......
