It will be more helpful if you could share a sample workbook.
Check the below link
Follow the steps up to creating donut chart you will get the what you required
Hope this helps
Plz mark this answer as correct or helpful to close the thread
Thanks a lot. Your answer helped me to create the donut chart I need.