how can i make a pie chart in excel and combine segments

If you want different labels on your chart you can press the right arrow button just beside data labels.

Then put a tick mark on the Data Labels You will see that the data labels are inserted into the slices of your pie chart.

1 st select the pie chart and press on to the “+” shaped button which is actually the Chart Elements option.

To add labels to the slices of the pie chart do the following. They are,īy using these options, you can easily modify your pie chart. After selecting the chart, you will find 3 options just beside it. To modify or edit an Excel pie chart you need to select the pie chart 1 st. Read More: How to Make a Pie Chart in Excel with One Column of Data How to Modify/Edit the Pie Chart Before inserting make sure to select the data you want to analyze.Īfter this, you will see a pie chart is formed in your worksheet.

You can also insert the pie chart directly from the insert option on top of the excel worksheet. From there select Charts and press on to Pie. In the Quick Analysis, you will find many options to analyze your data.

Now select the cells A3 to B8 and right-click on your mouse and press on to Quick Analysis.

Here we will be analyzing the attendance list of 5 months of some students in a course. In this example, we will see the process of inserting data from a table to make a pie chart. The first condition of making a pie chart in Excel is to make a table of data. Related Articles How to Insert Data into a Pie Chart in Excel

How can i make a pie chart in excel and combine segments