The important thing is that you saved me a lot of time researching the
solution. Thanks very much.
--
Brent


"Andy Pope" wrote:

Yes good catch. I should have set the height to 1 not zero.

Brent wrote:
Andy,

Thanks for the information. However I think you made a mistake. How about
=OFFSET($A$1,0,0,1,COUNTA($A$1:$AA$1))? This seems to work.
Brent


"Brent" wrote:


Hey Guys,

I am trying to create charts that are updated automatically using the
proceedure described in article 183446. I need to create charts from data in
rows rather than columns. I changed the range to A1:AA1, but I don't get the
expected result.. Could someone please describe the correct methode for me?
Thanks
--
Brent

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info