The table should be in a basic format with the first column containing the labels and the second column containing the values.įor example, we are going to create a pie chart that represents the big cat population in the wild (see below). To make a pie chart, first, you must set up your data in a basic table. In this article, we’ll give you step-by-step instructions for creating and customizing a pie chart in Microsoft’s Excel. Column charts are used for comparing data across categories and line charts are used for showing trends in a data series over time while pie charts are mainly used for showing the relative shares of categories in a total. Unlike line graphs or bar charts, we can only use a single data series in a pie chart.

And each slice (portions) represents a percentage of the overall total amount. Pie charts are a type of circular graph, which is divided into slices (portions). Pie charts are one of the most widely used charts used for data visualization because they are easy to read and understand. Learn everything about creating and formatting a Pie chart in Excel.

Steps to create pie chart in excel