Hi,
Try these explanations of dynamic ranges in charts.
See here for details on dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
You need to define the OFFSET formula as a named range rather than in a
cell. Then the chart uses the named formula to plot.
Cheers
Andy
> I saw another post with a similare title, but there was not enough info in
> there to tell me if I am trying the same thing.
[quoted text clipped - 12 lines]
>
> Thanks...

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Bill Brehm - 17 Oct 2006 07:29 GMT
Thanks for the tips. I think i'll be able to go from here.
> Hi,
>
[quoted text clipped - 26 lines]
>>
>> Thanks...