I want to make a radar chart that expands depending on how many mesurements I
do. If I make 50 measurements I want 50 y-values to be a whole turn, but if I
have 100 y-values I want that to be one turn. How can I make this work
automatically without needing to change the range in the source data?

I know how I would like to make it work, but I'm a bit confused since you
can't use formulas in the field where you fill in the data series.

Can anyone help me?
--
Anna

Hi,

You need to create a named range, which is explained here.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

Anna S wrote:
I want to make a radar chart that expands depending on how many mesurements I
do. If I make 50 measurements I want 50 y-values to be a whole turn, but if I
have 100 y-values I want that to be one turn. How can I make this work
automatically without needing to change the range in the source data?

I know how I would like to make it work, but I'm a bit confused since you
can't use formulas in the field where you fill in the data series.

Can anyone help me?

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!
--
Anna


"Andy Pope" wrote:

Hi,

You need to create a named range, which is explained here.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

Anna S wrote:
I want to make a radar chart that expands depending on how many mesurements I
do. If I make 50 measurements I want 50 y-values to be a whole turn, but if I
have 100 y-values I want that to be one turn. How can I make this work
automatically without needing to change the range in the source data?

I know how I would like to make it work, but I'm a bit confused since you
can't use formulas in the field where you fill in the data series.

Can anyone help me?

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

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

If you want to email the workbook I will take a look.

andy AT andypope DOT info

Cheers
Andy

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

--

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