Bullseye chart in Excel
What is bullseye chart?
Bullseye chart can be used to visualise the parameter in a particular range. Microsoft excel doesn’t have this as default chart type but it provides way to create one by combining couple charts like X,Y and Doughnut. here is one i have build for you.
How it works?
You can see that there are three categories. there are four level in every category. This chart can draw these categories and levels as well as plot the points in between them. All you need to do is just enter the data.
This chart is a combination of XY Scatter and Doughnut chart and using a little complicated calculation behind. you can use column outline in the file to see the calculation.
See more about Excel Chart here