Graphing coloumn data based on drop-down list

[gregersdk]

Hello experts!

I have a slight problem I hope You can help me with.

I have 5 coloumns with lots of data and I wish to graph one of them based on the choice of a drop-down list. To save computing power (lots of calculations are done in the scenarios), I'd like not to unnecessarily refer to another coloumn.

My data looks somewhat like this:

Scenario 1	Scenario 2	Scenario 3	Scenario 4	Scenario 5
data...	data...	data...	data...	data...

The options for the names in my dropdown list is the same as the scenario names in the coloumns.

I have tried looking up dynamic range, but they don't seem to fit, as I already have all my data. I just need for the user to be able to choose which scenario to graph himself/herself.

Any suggestions?

Thanks,


GregersDK

[misrasomendra]

Hi,

See the file, are you looking something like this.

Regards,

[Richard Buttrey]

Hi,

You're on the right lines with the dynamic range name.

You should use the value in the drop down list as a precedent value to another cell which reads the column number you've selected. e.g. assuming your data is in A1:E.. and the drop down is in say G1, in H1 add a formula

=MATCH(G1,A1:E1,FALSE)

Now your dynamic range name formula would be

Please Login or Register  to view this content.

so use this name for your chart.

[gregersdk]

Thanks! I ended up using a slightly simplified version of what is in misrasomendra's attached sheet (I have a fixed number of rows in my data, forgot to mention). This is now solved

Thanks a bunch, both of you