Use a dynamic named range using the offset function in the refers to part of
the name definition (Insert =Name=Define).

Make that (the defined name) the source for your chart.

--
Regards,
Tom Ogilvy

"Mike Harris" wrote in message
om...
i want to chart the last n entries in a column in an excel chart. the
total number grows. so, I want to chart the last entry and the
preceding 64. how would I do that?

thanks

mike