Radar chart - how convert data from 360 deg to every 10 deg

[AndyG]

Following on from a previous post , I have a set of data which is graphed using a radar chart.
The data is a signal value measured at 1 degree intervals, 1 to 360 degrees (actually 0 to 359 degrees) and the graph shows this at one degree intervals.
The problem is the graph is too 'busy' if the axes and labels are drawn every degree, every ten degrees would do fine . Can I specify the axes to display every ten degrees, if so how?
Alternatively, how can I write a formula that will look at the column of data 0-360 degrees and copy every 10th cell of data to a new column, so that the data is every ten degrees - this would be quite adequate for the graph

 

[fairwinds]

Hi,

If you have your data in e.g. A2:A361, try
=INDEX($A$2:$A$361,(ROW()-ROW($C$2))*10+1)
in C2, and drag down.

 

[AndyG]

Thats the job, thanks!