Radial diagrams

[Meltad]

Hi,

I'm trying to display my current projects in the form of a radial diagram in
Excel... I did Insert > Diagram > Radial diagram but was wondering whether
you can adapt this any further?... I've turned off the Autolayout to resize
circles individually but...

I need to add secondary level circles (eg a third level of circles coming
out of the existing circles) and to also colour code the circles depending on
task status. I've looked at Andy Popes website on charts but couldn't find
anything...

Any comments gratefully received! Thanks, Mel

 

[Andy Pope]

Hi Mel,

Perhaps you create the effect with multi series xy scatter chart.
You could increase the size of the circular data markers to create the
circles.
Or maybe a bubble chart.

Cheers
Andy