Right click on the bar and select Format Data Series. We need to make some modification to make the chart look beautiful. Step 4: This looks like an ordinary chart. You can use these charts as alternative as they are easier to compare the values.Step 3: Once you click on that chart, it will insert the below chart automatically. Note:- If you having the option of choosing a different chart type then, consider making a Bar chart or Column chart instead of Pie chart. To delete the legend, click on legend and then right click with the mouse.To Delete the legend, follow the below mentioned steps: To add labels to the chart, just right click on chart with the mouse, and a pop up 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, then 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, and 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, & 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. This pie chart contains the three type of charts in which 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: - This chart is used to show the proportion of the whole. In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |