| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making chart with hidden Data | Excel Discussion (Misc queries) | |||
| Excel 2003 radar chart - maximum discrete data points | Charts and Charting in Excel | |||
| Radar Chart | Charts and Charting in Excel | |||
| radar chart | Charts and Charting in Excel | |||
| about radar chart | Charts and Charting in Excel | |||
Linear Mode
