how to create a percentage pie chart in excel 2010

Defining class intervals for a frequency table or histogram.Pie Chart: - This chart is used to show the proportion of the whole. Bad graphical representations of data. In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010.License: CC BY-SA: Attribution-ShareAlike One thing that has helped me with transitioning from Excel 2003 is that Pivot Table Options> Display now has a 'Classic PivotTable layout' choice which might make this a little easier to maneuver if you set it before you start.Ī great source for Pivot Table info is Debra Dalgleish's site. Your pivot chart should now be charting the new field too. Right-click in that same cell, the one that now says 'Other,' and choose 'Expand/Collapse' and then 'Collapse Entire Field.' This hides the original Part Number field.

Select Design > Insert Chart, select a chart type, and then drop it on the form or report. To open, right click the form or report name in the navigation bar, and then select Form Design or Report Design. To create, select Create > Form Design or Report Design. Click into the cell with that label and, in the formula bar, type 'Other.' That changes the name of the new item. Beginning steps Create or open a form or report in Design view. In this new field there will be an item called 'Group1'.You'll now have a new field called 'Part Number2' in your field list and to the left (if it's a row field) of the Part Number field.Select the items that you want to group into your 'Other' category.In your pivot table you'll need to sort the items in Part Number so that those with the smallest values are together.I'm imagining a Pivot Table with a field called 'Part Number.'

How to create a percentage pie chart in excel 2010