Dear All,
Maybe someone knows how to calculate a surface of radar chart for one series.
Your support will be apreciated, very much
Thanks & regards
elka
Dear All,
Maybe someone knows how to calculate a surface of radar chart for one series.
Your support will be apreciated, very much
Thanks & regards
elka
Hi,
Break the problem down by calculating the area of each triangle in the
radar plot and then summing them.
Assuming your data series for a 3 point radar chart is in A1:A3 put this
formula into B1 and copy down to B3.
B1: =0.5*A1*A2*SIN(DEGREES(360/3))
To make the last points formula work you will need to reference point 1.
The easiest way to do this is to add a formula in A4 which references A1
A4: =A1
To find the area sum B1:B3
Cheers
Andy
elka wrote:
> Dear All,
> Maybe someone knows how to calculate a surface of radar chart for one
> series.
>
> Your support will be apreciated, very much
>
> Thanks & regards
>
> elka
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
thanks Andy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks