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.

Bullseye chart

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

Join my whatsApp group to discuss more

Download a working file   – Please Share if  you like it

Bullseye-Chart-Working-File.xlsm (11 downloads)

1 reply

Trackbacks & Pingbacks

  1. […] Download the chart from here […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *