Incorporating OFFSET into Chart References

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 17 Aug 2006 17:11 GMT

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.

Reply to this Message

Barb Reinhardt - 17 Aug 2006 17:36 GMT

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

> 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.

Reply to this Message