how to make a pie chart in excel with words

Just double click a data label, then uncheck value and check percentage. Because the data shows a part-to-whole relationship - in other words, everything adds up to 100% - we can tell Excel to show a percentage instead of just the number. To start off, I'll resize the chart and bump up the text size. I'll use Insert, then select the pie chart option.Excel builds the chart.Īs always there're some things here we want to change. I'll leave the data for now, and lock the reference inside SUM so I can sort the categories later if I want without any problems. Now I'll just use the SUM function to gather up the rest of the data in the 'other' category. We want a small number of categories so I'm going to insert 2 rows after Safari, then add a new category called 'Other'. Just select and copy the data, then use Paste Special with Transpose. The horizontal layout of this data is kind of awkward so let's transpose the data to a vertical format first. Pie charts show a 'part to whole' relationship, and they work best with a limited number of categories. Let's build a pie chart to plot this data. Here we have data that shows market share for desktop browsers in 2016. Step 4: Modify the appearance (optional).In this video, we'll look at how to create a pie chart in Excel. The doughnut chart will automatically update with a second outer layer: In the new window that pops up, click Add to add a new data series.įor Series values, type in the range of values fpr Quarter 2 revenue:Ĭlick OK. Right click on the doughnut chart and click Select Data. Step 3: Add a layer to create a double doughnut chart. The following doughnut chart will automatically appear: On the Data tab, in the Charts group, click the icon that says Insert Pie or Doughnut Chart. Perform the following steps to create a double doughnut chart in Excel.Įnter the following data into Excel, which displays the percentage of a company’s revenue that comes from four different products during two sales quarters: This tutorial explains how to create a double doughnut chart in Excel. It’s similar to a pie chart except it has a hole in the center, which makes it look more like a doughnut.Ī double doughnut chart is exactly what it sounds like: a doughnut chart with two layers, instead of one.

A doughnut chart is a circular chart that uses “slices” to display the relative sizes of data.

How to make a pie chart in excel with words