Various amount of data when making a radar chart

[Anna S]

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?

 

[Andy Pope]

Hi,

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

Cheers
Andy

 

[Anna S]

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]

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]

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

 

[Andy Pope]

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

andy AT andypope DOT info

Cheers
Andy

 

[Anna S]

I can't email the workbook because there is some sensitive company
information in it. How those it work to create the new x-values etcetera if
you have the data on one sheet and want to make a graph on another? Can it be
that that causes the trouble?

Cheers
Anna

 

[Andy Pope]

You could always substitute the actual values for fake ones in order to
protect company information.
I'm only interested in the layout of the data as that is what appears to
be causing you problems.
Having the data on a separate sheet is not a problem as long as the
named range refers to that sheet and the series formula also include the
valid references if the named ranges are not at the workbook level.

Cheers
Andy

 

[Anna S]

Hi again,

I've just emailed you.
--
Anna

You could always substitute the actual values for fake ones in order to
protect company information.
I'm only interested in the layout of the data as that is what appears to
be causing you problems.
Having the data on a separate sheet is not a problem as long as the
named range refers to that sheet and the series formula also include the
valid references if the named ranges are not at the workbook level.

Cheers
Andy

 

[Andy Pope]

Anna's problem has been resolved.
Different locale settings for separator characters meant the formula needed
to be amended to take into account , and ; differences.

Cheers
Andy