Radar Charts - Circular versions

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

<phillips_sarah_ann@yahoo.co.uk> wrote in message
news:6e7104ef-37b0-4d18-90ce-e2e151acfef7@l42g2000hsc.googlegroups.com...
>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

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
<phillips_sarah_ann@yahoo.co.uk> wrote in message
news:6e7104ef-37b0-4d18-90ce-e2e151acfef7@l42g2000hsc.googlegroups.com...
>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

If you want a polar plot, here's a technique to try, from Stephen Bullen's
web site:

http://oaltd.co.uk/DLCount/DLCount....le=FunChrt6.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<phillips_sarah_ann@yahoo.co.uk> wrote in message
news:6e7104ef-37b0-4d18-90ce-e2e151acfef7@l42g2000hsc.googlegroups.com...
>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

On Mon, 14 Jul 2008, in microsoft.public.excel.charting,
phillips_sarah_ann@yahoo.co.uk said:
>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?

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.

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.