circular position radar chart labels

**hansma** · 08-30-2010, 03:33 PM

Hi everyone,

i'm a teacher trying to make an radar chart with the human development data (2009) of every country in it. It works just fine, except for the country labels. I can't change the position in such way that every label direction is away from the centre of the radar chart. In the alignment menu i can change the position, but every label directs in the same position. I hope i made myself clear.

thank you very much,

Hans

**teylyn** · 08-30-2010, 05:22 PM

Hello Hans,

Excel chart labels are not very flexible. Some would even call them rather limited. I think I understand what you want to do, but I'm pretty certain it's not doable with Excel 2003 standard formatting.

cheers

**Andy Pope** · 09-05-2010, 06:37 AM

Here is something I created back in 2005.

Of course nowadays we would suggest you use a bar chart

**hansma** · 09-10-2010, 04:17 AM

Hi,

teylyn and andy pope, thank you for your answers. I looked at the excel sheet of Andy, it's what i have i mind, but it doesn't look good in my graph. Look at my attachment and you will understand my problem. Hdi 2009 is without the macro and hdi 2009 with macro andy is of course with andy's macro.

Hans

**hansma** · 09-10-2010, 04:24 AM

To be honest,

the chart in the attachment is what i have as an example. I used it several times in my class room but the data is out of date, so i wondered, i couldn't be that difficult to create it myself and change the data every year.

Hans

**Andy Pope** · 09-10-2010, 08:22 AM

First you did not adjust the formula to use your data.
Then you did not update the code to pick up the results from the new location.

Anyhow I have updated the sheet and revised the chart slightly to have the circular labels, shading and data line.

Again I think this would be much easier to read and understand if you used a bar chart.
A case of just because you can does not mean you should.