Thread: Need to make a "dartboard" chart

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?

In article <379A9683-0675-4596-94A6-6E532F4D5634@microsoft.com>,
Camerhill@discussions.microsoft.com 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

Camerhill,

I think a radar chart, with a little tweaking, can do what you want .

If your department names are in column A, and the percentages are in column
B, put this in column C in C2, and copy down:

=100%-B2

Now select column A and Column C (use the Ctrl key). Make a radar chart.

You'll want to remove the axis labels (0-100%), since they're backwards, and
there doesn't seem to be an option to reverse the axis. Format - Axis -
Patterns tab - Tick-mark labels: None. The formula in column C reverses the
percentages, making higher percentages get plotted closer to the center.

You'll want to remove the lines connecting the points. Right click a line,
Format data series - Pattern tab - Line: None.

--
Earl Kiosterud
www.smokeylake.com

Copy down.
"Camerhill" <Camerhill@discussions.microsoft.com> wrote in message
news:379A9683-0675-4596-94A6-6E532F4D5634@microsoft.com...
> 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?

I am looking for a similar chart however I need it to remain circular not like the radar plot and it needs to have more than one axis with some easier input than plotting point by point department darts. Is there a formula to set a macro to:
1) evenly space a variable number of departments around a circle with 100% at the center
2) allow each department to contain up to 4 different point plots
3) make it so I don't have to zoom 300%