how to create pie chart in excel from a worksheet

In the following data set, we have monthly sales data of different categories of a grocery store. As might be expected, we need to create a PivotTable before using the PivotChart feature. In addition, we can easily make a Pie Chart from the PivotChart option by following some simple steps.

Making a Pie Chart with Multiple Data from Pivot Charts Option Read More: How to Make Multiple Pie Charts from One Table (3 Easy Ways)Ģ. Afterward, from the drop-down choose the 1st Pie Chart among the 2-D Pie.Īfter that, Excel will automatically create a Pie Chart in your worksheet.After that, click on Insert Pie or Doughnut Chart from the Charts group.First, select the dataset and go to the Insert tab from the ribbon.Now, we will add a Pie Chart to show this dataset graphically. In the following data set, we have Samuel’s monthly expenses for different household activities. In the beginning, you can utilize the Recommended Charts command to make a Pie Chart in Excel with multiple data.

In this section of the article, we’re going to learn how to add a Pie Chart in Excel with multiple data points. In that case, you may create a Pie Chart for sum by category if you find it necessary.Ģ Ways to Make a Pie Chart with Multiple Data in Excel If the dataset is comparatively large, then the use of Pie Chart might not be a viable option. Note: One thing to remember is that we will use Pie Chart for a relatively small amount of data. With the help of a pie chart, we can show the sales of different flowers graphically.

They are also sized according to their respective fractions.įor example, let’s consider sales of flowers at a shop. In a Pie Chart, each portion of the pie is proportional to the fraction of the data provided. A Pie Chart is a graphical representation of statistical data in the form of a pie.

How to create pie chart in excel from a worksheet