Sorry, that was my mistake. But it does not work even with the formula you
sent me.
--
Anna


"Andy Pope" wrote:

Those trailing $'s will cause a problem, try

=OFFSET('Calculation, Airgap'!$F$14,0,0,COUNT('Calculation,
Airgap'!$F:$F),1)

Cheers
Andy

Anna S wrote:
Thanks for giving me the information, but I still can't get it right. When
I'm going to create my new x-values and y-values using typing quite the same
as mentioned on the page about "Dynamic Charts". The programme says that its
something wrong with the formula

=OFFSET('Calculation, Airgap'!$F$14,0,0,COUNT('Calculation,
Airgap'!$F$:$F$),1)

But I can't see it...

Thanks for your help!

--

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