is there a formula-based solution for graph ranges?

[jrtaylor]

Hi geniuses,

I'm building a workbook with multiple worksheets.... maybe 20 or so.

In each worksheet, the layout of the data is identical EXCEPT for the range for a graph.

This range differs from one worksheet to the next. Different starting points, and different ending points.

I've tried using named ranges but I don't know how to make them relative to each worksheet. I've tried to come up with a workaround using ADDRESS, OFFSET etc. functions to name the beginning and ending cell addresses.

I'm attaching a small sample. The actual worksheet has thousands of additional cells and associated formulas (for each tab).


Thanks!