how to make a pie chart in excel with multiple data

If we want to change the colors of the division, select the required division as below.

If we want to change the design, a “Design” menu will appear on the top when we select the chart, and we can select the required design. Select the “Category Name” and deselect the value if we want both select both options. Select the chart, and right-click from the popup menu select the “Format data labels.”įrom the “Format Data Labels” menu on the right-hand side. In case if we want to add the expenses category to the division. Click on the “+” symbol and select the Data labels option. In case if we want to add the amount alone to the division. Now each division on the chart represents its name and contributed percentage. Once we choose “Add Data Callout”, the chart will have details like below. From that drop-down, select the option “Add Data Callouts”. Right-click and choose the “Add Data Labels “option for additional drop-down options. Now our task is to add the Data series to the PIE chart divisions.Ĭlick on the PIE chart so that the chart will get a highlight, as shown below. At the bottom, there is a legend that will help to understand what color represents what division on the chart.īut it will be difficult to check the description in the legend and check it on the chart. The chart will look like below.Ī PIE chart is created with different divisions, and each division is represented with different colors. First, we will select the first PIE chart from 2D charts. Select the type of PIE chart we want to create. Now go to PIE chart options which are already explained earlier.

The creation of a PIE chart is very easy. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).

How to make a pie chart in excel with multiple data