Selectable X-Axis Range

I'm trying to have a chart X-Axis that has only a range the user selects via a drop-down list. I've tried a lot of solutions such as offsets, indexes, and named ranges, and I'm not finding a good solution.
I've uploaded a sample of what I'm trying to do. Any help would be greatly appreciated!!! Thanks so much!!

Originally Posted by MrShorty

Have you tried using Autofilter? In your file, I:

1) Select the chart and expand the source data range to include the full table.
2) Select the chart and format the chart area so it does not move or size with cells.
3) Select the data table -> Data -> Filter to set up the autofilter.
4) Select the dropdown arrow on the "include" column and tell it to only show records where include has a "Y" in it.

Would something like that work for you?

Yes, that works. Thank you. I had to create a new tab with the data, and then a macro to select "Y" in the filter. Thanks again!

Originally Posted by Andy Pope

This uses INDEX to create label and Front data references. Then Offset for the other series data

Thanks much! I'll give it a shot. Thanks again!