Archery target chart

**sport_logo** · 11-09-2009, 11:33 AM

Hi all,

I need to design a chart that replicates an archery target. I have tried doing this using a radar chart but to no success. The data I would like to input for example would look like this:
Arrow Number Score Position
1 10 7
2 9 6
3 9 5
4 10 2

the data plot would be similar to that of an x,y plot graph with the score value as above and also the position value which is like a clock face reference. So the first arrow is a ten at 7 o clock for example. The archery target would also need to look like the attached bitmap file with ten circles ranging from a score of 10 in the middle to a score of 1 on the outside.

is this possible to do?

Thanks!!!

**shg** · 11-09-2009, 11:36 AM

Make a graphic of an archery target (Visio comes to mind, but any drawing program would do), save as a picture file, and use it as a fill effect in an x-y chart.

**Andy Pope** · 11-09-2009, 12:10 PM

this uses a filled radar to produce the target.

xy-scatter for the arrows with formula to calculate distance and angle from your score and clock position information.

**sport_logo** · 11-12-2009, 12:32 PM

hi all,

Thanks for all the help. I have decided to go with a picture of an archery target through the fill effect in a scatter plot. Need to find a clearer one on the attached file but will do in the meantime. I still need to work out a formula to relate the arrow scores to the chart on the attached spreadsheet. for example a 1.5 @12 would be in the middle of the outer ring at 12 o clock and a 2.0 @ 6 would be on the line of the second ring at 6 oclock. If the centre of the graph relates to 5,5 on the x,y axis is there a conversion formula?

also the bullsye (innermost ring) is generally referred to as an x. is it possible to for excel to recognise a letter rather than numerical values and put it the x ring?

Thanks

**Andy Pope** · 11-12-2009, 12:41 PM

Using the formula in my example change

P3: =IF(N3="x",0,11-N3)

In your chart if you change the scales to be +/-10 the formula should work

**shg** · 11-12-2009, 12:42 PM

Change the chart axes so that the center is 0,0 and the min/max values are appropriate (+-10?).

Then the x position is radius * sin(radians(30 * clock)) and the y position is radius * cos(radians(30 * clock)).