Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#3
|
|||
|
|||
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In a chart how do I make the bars bigger? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
how do i make one chart that my ees can input info, and have a se. | Excel Worksheet Functions | |||
How do I make a section of a chart line dotted? | Charts and Charting in Excel |