how to make a pie chart in excel for all states

#How to make a pie chart in excel for all states how to#

Here we select Legend so a new window will come up name Format Legend. To select the other format options, click on the drop-down button of the Label Options. Here we opened the Format Data Labels option as we select the More Options from Data labels. Excel allows you to edit your chart the way you want with this option.Īfter clicking this option, you will get to see a window opens up on the right side of your worksheet.

In every Chart Elements option, you will find More Options just after clicking the right arrow button. Just click on your chart and on top of your Excel worksheet click on the Design option under Chart Tools. It`s a direct approach to edit your chart where you can find all the options that you want. You can simply do the above things by also using the Chart Tools toolbar in Excel.

#How to make a pie chart in excel for all states how to#

Read More: How to Edit Pie Chart in Excel (All Possible Modifications) Edit a Pie Chart Using the Chart Tools See the following picture for a better understanding.Īfter removing the tick mark from the category press on the apply button to proceed with the filter option.Īs you can see the chart is automatically modified after performing the filter option. You can simply remove the selection using this Chart Filter option to obtain a new pie chart with the rest of the data. 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. 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