Various amount of data when making a radar chart

  • Thread starter Thread starter Anna S
  • Start date Start date
A

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?
 
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!
 
Those trailing $'s will cause a problem, try

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

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

andy AT andypope DOT info

Cheers
Andy
 
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
 
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
 
Hi again,

I've just emailed you.
--
Anna


Andy Pope said:
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
Click to expand...
 
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
 
Back
Top