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.