Chart data based on cell reference

I'm wondering if it's possible to do this. Say I have data in A1-A1000 (these are my x-values) and B1-B1000 (these are my y-values). Let's say in cell C1 is my low value and cell C2 is my high value. Is it possible to make a chart (scatter plot) that just plots the data between C1 and C2? For example, let's say C1 is 10 and C2 is 500, the chart would only plot the data in A10-A500 and B10-B500. Thanks!

Create to named ranges using the following formula:
xValues

Please Login or Register  to view this content.

yValues

Please Login or Register  to view this content.

Create your chart.
Change the Data source to the named ranges.

I've attached a sample

Thanks for your help. One question, when I copy the worksheet (in the same workbook) it looks like the x and y axis no longer use the named ranges. Is there a way to get this to work even if the worksheet is copied? Thanks!