changeable graph based on drop down list

Hello geniuses

I wonder if this is a quick one, I've attached a basic workbook to try get across the setup I have.

Essentially in the drop down (yellow) I want the graph to display just the data from that borehole when it's selected, and all the data when the drop down is empty... Is this possible without a macro?

Best regards,
Sean

Sounds possible, however, there's no attachment, Sean.

BSB

Oops!!

Here it is

I found out how to do it,

I just used an if function to display whether or not the data would display based on the drop down.

Then defined the range using the name manager in the formula tab

Cheers!