how to make a pie chart in excel for all states

We can only use the data in rows or columns in creating a doughnut chart in Excel. The categories represented in this chart are parts, and together they express the whole data in the chart. Note:- If you having the option of choosing a different chart type consider making a Bar chart or Column chart instead of Pie chart, you can use these charts as alternative, it easier to compare the values.A doughnut chart is a chart in Excel whose visualization function is similar to pie charts. To delete the legend click on legend and then right click with the mouse.To add labels to the chart just right click on chart with the mouse, a pop will appear.

Then drag the handle in or out to change its size.Point the one of the dotted handles on the border of the chart where the pointer will change to a two headed arrow.To move the chart just click and hold the mouse pointer on the chart and drag it and release the pointer.The chart will show the heading from the number column as a chart title, and a legend with the text descriptions if your data includes those.Then click the first Pie option, at the top left.Go to the Insert tab, Select 3D Pie Chart from the Chart Group.To prepare the Pie chart follow below mentioned steps:. We have another table of Targets & Require sold unit per zone. Column A contains the Zone Name, Column B Sold, & in cell B11 is having total sold unit.

We have a table from Range “A6 to B11”, which is having Zone & Sold unit with total sold unit. Pie chart generator is containing the three type of charts: - 1st is 2D Pie Chart, 2 nd is 3D Pie chart and 3 rd is Doughnut Pie chart. Use it when numbers are equal to 100% and the chart contains only few pie slices (many slices make the angels hard to estimate). Pie chart is used to show the proportion of the whole.

How to make a pie chart in excel for all states