How to Change Pie Chart Colors in Excel (4 Easy Ways).How to Make Two Pie Charts with One Legend in Excel.Read More: How to Show Percentage and Value in Excel Pie Chart Finally, this is the output of our first method.Then, we added a Chart Title, increased font size, and moved the Data Labels a bit to show the Leader Lines.By doing so, the Pie Chart will look like this.Next, select Outside End from the Label Position section.After that, select Category Name, and Legend Key from the Label Contains section.Then, the Format Data Labels box will appear on the right side of our Workbook.Thirdly, from the Data Labels → select “ More Options…”.This will move the Legend to the right side of the graph. Secondly, from the Chart Elements → Legend → select Right.Hence, this will create a basic Pie Chart and we will modify it next.Then, from the Insert tab → Insert Pie or Doughnut Chart → select Pie.Therefore, select the cell range B20:C23.So, this will AutoFill the formula to the cells.Moreover, it is mandatory to use the absolute cell reference in this case. This formula finds the number of occurrences of the unique values in the cell range from the dataset.Once you’ve selected the most applicable chart for you, click it so that it can be added to your page in Excel.However, you can hover the cursor over your preferred pie chart option to see a sneak preview of what it will look like for your data. This includes 2-dimensional and 3-dimensional pie charts. You should now be able to see various options for creating your pie chart.Then click the Insert Pie or Doughnut Chart option (you can’t miss it, it’s in the shape of a small pie chart). Do not select the sum of any numbers as you probably don’t want to display it on your chart. In your spreadsheet, highlight the data that you want to plot on your pie chart.If you opt to label your data then these will be transferred to your pie chart later on. Create your columns or rows of data (or both if need be).Though there are different types of pie charts available to choose from on Excel, it won’t be difficult finding the perfect way to showcase your data.Īll you need to do is follow these steps and you’ll be on your way to visualizing your data in no time at all! This is the most straightforward way to create a pie chart in Excel.

Make a pie chart in excel mobile