View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Radar Charts - Circular versions

Hi,

As Bernard's say you need more points in order to create the curves.

Assuming your 8 points, including category labels, are in A2:B9, enter this
formula in C1
=Max(B2:B9)
In C2 enter the formula
=$C$1
Draw this formula down for 360 rows, to C361.

In the chart add a new series based on C2:C361.
Select the original series and plot on the secondary axis.
Select category labels and delete.
Select the value axis and set the Pattern to none.

You should now have just the required category labels and axis spokes with
the gridlines being curved.

Format the extra series to have no pattern line or colour.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
I am trying to make a round radar chart, is there anyway I can do this
in Excel? I can use excel's radar chart option but it produces an
Octogon and I need the result to come out as a circle. If it can't be
done in Excel are there any add-ins out there that could help?

All help gratefully received.

Sarah