Radar Charts - Circular versions

  • Thread starter Thread starter phillips_sarah_ann
  • Start date Start date
P

phillips_sarah_ann

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
 
I sounds like you have two few points to make the circle.
Think about what an XY chart would look like if you gave it just four points
from a circle. You would get a rectangle.
best wishes
 
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
 
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?
Click to expand...

In my experience it takes at least 24 points to produce a decent circle
in a radar chart, so produce your eight points three times each, or more
if you want a more convincing circle.
 
Back
Top