In article ,
says...
Hi

I need to make a business chart in order to track percentages; the idea is
that it's circular, with the centre being 100% and the outside rim being 0%.
Each department will have a "dart" (i.e. a point on the chart) showing what
percentage they've achieved, the closer to the centre the better.

Is there a template anywhere which might help me with this?

Interesting idea. Not difficult to create. Use a bubble chart with
all points centered at the same (x,y) coordinate and bubbles of
different sizes. For example:

0 0 100
0 0 75
0 0 50
0 0 25
0 0 2

where the first 2 columns are x,y values and the last represents the
bubble sizes. Double-click the plotted series and from the Options tab
check 'Vary colors by points,' for 'Size represents' check 'Width of
bubble,' and set 'Scale bubble size to' to 300%.

For some reason, XL leaves a lot of white space on a bubble chart (yes,
even with the 300% setting). But, you can expand the chart to fill up
the computer monitor

Set the x-axis and y-axis min to -1 and max to +1.

Also, set all of the following to none:
X-axis: Line and tick mark labels
Y-axis: Line and tick mark labels
Chartarea: Border and area
Plotarea: Border and area.

The final effect will be a set of concentric circles in your worksheet.

To add the department 'darts' add data values such as
0.25 0 5
0.1 0.1 5

and add these as new *points* (not new series) to your chart.

You can also add data labels if you want.

Looks really nice if I say so myself. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions