Select your data set and in the Insert tab, then select the pie chart from the chart options. Keep in mind, that a pie chart can only visualize a single data series.
The following formatting options are available: Fill & Line Effects Series Options Now let me show you some minor formatting that you can do to make your Pie chart look better and more useful for the reader. This will open a pane (or a dialog box) with all the series formatting options. In your spreadsheet, highlight the data that you want to plot on your pie chart. To format the series, right-click on any of the slices of the Pie chart and click on ‘Format Data Series’.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). Step 2: once you click on a 2-D Pie chart, it will insert the blank chart as shown in the below image.
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.