Dartboard / Bullseye Style Graph

Hi everyone,

I am a teacher and want to create a specific chart to track academic target levels against current the levels students are achieving.

My idea is to create a chart with 3 circular bands to it, Green, Amber and Red - starting from the centre and working outwards. Ideally I would like the graph to show students who were closer to their target level in the centre (Green band), with those students who were further away from their targets being placed further out on the graph (Amber) and those way off in the Red band.

Just wondering if someone could give me some advice on how to create such graph.

many thanks,

Becuase the chart you're describing is a plane rather than a line do you have a view as to what determines the students location in respect to their 'y' position from the bulls eye? For example a student in the second coloured band can be plotted to the right of the bulls eye, above the bulls eye, below or to the left and will still be the same distance in each instance. It sounds like you just want them randomly placed in the correctly coloured band. Is this right?

OK. You didn't come back so I knocked this together. Its a radar chart set up with three rings to look like the bullseye target. I've put 25 dummy student records in here.

At present it plots the offset from the highest score. ie if the highest score in the class is 98 then that student gets 0 offset (the bullseye) and all others are measured from this point. You can change the formula if you want them all measured to say 100%. The ring sizes are set on the based on an arbitrary size I guessed at. feel free to chnage these too.

Excel does some weird stuff when you combine filled radar and nonfilled radar - it creates an extra category. With lots of date points this shouldn't be a problem but if it bothers you someone on the forum might have a work around.

Also Excel isn't real good on the labelling. There's macros on this forum though that might assist on fixing the labels to get them closer to teh points. Do a search on this forum.

trial bullseye chart.xlsx

Thanks Crooza, much appreciated. I don't mind students being randomly placed on the graph. I will put some of my test data into the graph and let you know how it looks. Again, many
thanks!

Originally Posted by RedmanJP

Thanks Crooza, much appreciated. I don't mind students being randomly placed on the graph. I will put some of my test data into the graph and let you know how it looks. Again, many
thanks!

I'd leave them random too. If you sort by their score you'll get them distributed like a corkscrew.

Hi,

I have just got around to testing your trial bullseye chart and it is great, exactly what I am looking for, thank you! As you eluded to in your original post the only improvement I would like to make is to try and move the labels closer to the points. I have had a look at the forums but am struggling a little as Macros are by no means my strong point - would you be able to point me in the right direction here please....?

Hi,

I'm neither a macro or a chart expert but the attached file has a macro that brings the labels closer to the points. Depending on how many points you have you may or may not get a better result as the points close together tend to make this messy.

When you open the file the chart won't have any labels at all.

click on the chart then click the big button to run the macro.
I'm effectively bringing the labels 25% closer to the centre of the graph.

Someone brighter than me may be able to work out how to link the label position directly to the points position but I couldn't do that. If you think 25% reduction is not enough or too much open teh code and chnage the 0.75 factor to 0.6 or 0.8 (or something else if needed) to adjust.

Let me know if this works OK or not

Andy

Thanks for jumping in. You seem a bit more switched on than I am. Is there no way to link the label position in the radar to the actual point position?

Your xy solution might be better.

The OP specifically wanted it to look like a bullseye so while bar chart might be a good solution it wasn't what they were after so I steered clear of this.

Hello everyone:
How can you change the center of the bulls eyes? I want the center to move by -20% and +30%.