Offset/Match? Chart by selected start/end date and col header

Hello,

I'm trying to chart a range of data based on 3 variables. First 2 are variable (selected) start and end months and the 3rd is based on the selected column header.

I think I need some kind of offset formula but I'm lost...

Appreciate any help with this.

Thanks, Steve

Ben,

Thanks for the solution - however, I'm not yet comfortable using macros for this kind of thing. I'm afraid I won't be able to fix or maintain the s/s when I break it - and I will break it, eventually. Any formula based solution?

Steve

Hello Steve
One way using formulas is to create a couple of dynamic named ranges and apply them to your chart. See attached.

Hope this helps.
DBY

Exactly what I needed DBY! Thank you.