How to Make a Pie Chart in Excel 2020: A Step-by-Step Guide

Creating a pie chart in Excel 2020 is a straightforward process that requires a few clicks and some basic formatting options. In this article, we will walk you through the steps to create a pie chart and also explore how to add data labels and format your chart.

To start, select the pie chart and right-click on it. From the context menu, choose 'Format Data Series.' This will open up the Format Data Series pane where you can adjust various settings such as the fill color, border style, and font size for your pie chart.

Once you have formatted your pie chart to your liking, you can add data labels for each data point. To do this, select the pie chart and right-click on it again. From the context menu, choose 'Add Data Labels.' This will add a label to each slice of the pie chart displaying the corresponding value.

If you want to create a more detailed pie chart that separates small slices from the main pie, you can use the 'Pie of Pie' or 'Bar of Pie' feature in Excel 2020. To do this, click on the 'Insert' tab and then choose 'Pie' > 'Pie of Pie' or 'Bar of Pie.' A dialog box will appear where you can select the data range for your chart.

In this example, we will use cells A2:B9 as our data range. First, create the data that you want to use by entering values into these cells. Then, highlight the cell range and click on the 'Pie of Pie' or 'Bar of Pie' button. Excel will automatically create a pie chart that separates small slices from the main pie.

The resulting pie of pie or bar of pie chart provides a clear visual representation of your data, making it easier to identify smaller slices and trends in your data. With these simple steps, you can easily create a pie chart in Excel 2020 and gain insights into your data.

How to make a pie chart in excel 2020