View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Anna S Anna S is offline
external usenet poster
 
Posts: 11
Default 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