See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

If you do use a method other than OFFSET, remember to include the worksheet
name in your named formula. That *should* work; no promises, though.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is it possible to use INDIRECT references in Data Source of Chart?
If so, is there some trick?

Goal: Chart with several Data ranges which need to be extended
as data is appended to a running list.

I wish to create a cell with the necessary elements to create the
source data reference indirectly.

Or a better way to do this easily....

Thanks