how to make a pie chart in excel with categorical data

This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category 'Necessary'. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'. The cookie is used to store the user consent for the cookies in the category 'Analytics'. These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. This further highlights the need for labelling. Moreover, one of the top criticisms for pie charts is the difficulty in interpreting angles and ranking the segments, especially if not sorted by highest to lowest. They are difficult to understand on their own and rely on descriptive annotation. It is argued that this demonstrates why they are ineffective. Pie charts often have labels of the category names, together with their relevant proportion and value. However, those concerned with data visualisation best practice will know pie charts remain a contentious visual. Food references aside, pie charts are a default charting option in most visualisation tools such as Tableau and Power BI. Pizza chart would be an equally appropriate name, but perhaps has less of a ring to it. Its name is derived from how each section resembles a slice of pie. In other words, the ‘parts’ are proportional categories with a combined total of 100%. Pie charts are a popular visualisation choice used to represent a part-to-whole relationship.

How to make a pie chart in excel with categorical data