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 Radar. here is one i have build for you.

bullseye chart excel

How it works?

You can see that circles are splited into pies, the PIEs are categories. there are three level in every category.

Bullseye chart is a combination of XY Scatter and Radar 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 (239 downloads)

1 reply

Trackbacks & Pingbacks

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 *