Various amount of data when making a radar chart
 

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

Various amount of data when making a radar chart
 

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?

Various amount of data when making a radar chart
 

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?

Various amount of data when making a radar chart
 

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

Various amount of data when making a radar chart
 

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

Various amount of data when making a radar chart
 

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

Various amount of data when making a radar chart
 

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" wrote:

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

Various amount of data when making a radar chart
 

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 wrote:
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" wrote:


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


--

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

Various amount of data when making a radar chart
 

Hi again,

I've just emailed you.
--
Anna


"Andy Pope" wrote:

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 wrote:
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" wrote:


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


--

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

Various amount of data when making a radar chart
 

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

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andy Pope" wrote in message
...
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