Hello!,

I am using a named range (dynamic: with offset and counta, to include
additional rows automatically) as my chart source (Office 2007). But i
noticed that every time I run the chart it changes the source to the
range itself (absolute) and not using the source as named range.

This is not done through vba.

Is there a way that I can use a dynamic named range in a chart (Office
2007)?

Thanks,

Abdul