Incorporating OFFSET into Chart References

[Guest]

I would like to include the offset function into chart references but Excel
is not letting me. For instance, under the series tab in the chart process,
I would like to change these X values =Sheet1!$A$1:$A$25 to
=sheet1!offset($A$1,0,0,35,1)
but I keep getting an error.

 

[Guest]

It seems as though I've seen Jon Peltier show an example of that on his site.
Take a look here

http://peltiertech.com/Excel/Charts/index.html#hdrDyno