Suppose in your chart you don’t require a data now. This feature allows you to analyze your chart deeply. You can filter your chart anytime by using the Chart Filters option. # Using the Chart Filter to Filer Your Pie Chart You can choose various color options along with the monochromic colors. Use the drop-down option there to find that and select that style for applying in your chart. Suppose you want to show the numbers on your chart with the legend. One is the style option the other one is the color option. You will find 2 options after clicking that.

To impose different chart styles and colors click on the Chart Style option. # Customizing Style and Color of the Pie Chart To do this, put a tick mark on the Legend option in Data Elements and for inserting various legend options click on the right arrow button beside the Legend option and select the legend option of your choice. Similarly, just like inserting labels in your chart, you can also insert legend. You will find different labeling options.

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. Read More: How to Format a Pie Chart in Excel # Adding Labels on Slices 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. 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. Conclusion How to Insert Data into a Pie Chart in Excel

How to add footnote to chart in excel