Dynamic Scatter Plot help

[seabrookk]

Hello!

I am trying to build a dynamic scatter block for reaches in Rivers The basic set of the data is as fallows:

River : Reach : X : Y :
Bear 1 0 156
Bear 2 10 158
Bear 3 20 162
Bear 4 30 154
Deer 1 0 133
Deer 2 10 145
Deer 3 20 178
Deer 4 30 180

Basically what I want is to be able to fill in a two cells one for River and another for reach and it dynamically displays the correct scatter plot.

Is this possible?

Thank you!

 

[seabrookk]

Actually, I more exact example of my data would be:

River : Reach : X : Y :
Bear 1 0 156
Bear 1 10 158
Bear 1 20 162
Bear 2 30 154
Bear 2 40 154
Bear 2 50 154
Deer 1 0 133
Deer 1 10 145
Deer 2 20 178
Deer 2 30 18

the goal would be to select; River: Deer Reach: 1 and get a scatter plot of the first 3 entries. and then get a scatter plot of all combinations of my data.

Thank you!!

 

[seabrookk]

Anyone have something?

I'm testing theories that involve a lot of Offsets Indexes and Countifs... thoughts?