how to format your data to make a pie chart 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. To enter the title of chart, click on highlighted. Select the first cell and drag cursor till the last cell to select whole data. This includes 2-dimensional and 3-dimensional pie charts. If plain white feels like a dull background for your pie-chart, you can also create it against a background image in Excel. 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.Hover over a chart type to read a description of the chart and to preview the pie chart. Select Insert Pie Chart to display the available pie chart types. Well start this tutorial with a table and a pie chart shown based on the data. If you opt to label your data then these will be transferred to your pie chart later on. To create a pie chart, highlight the data in cells A3 to B6 and follow these directions: On the ribbon, go to the Insert tab. Adding Percentages to Pie Chart in Excel. 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.

How to format your data to make a pie chart in excel