Posts

The Pie of Pie Chart is a built-in chart bang out in Excel. Pie charts work best to display data with a small number of categories (2-5).

A Pivot Table is a special tool in Excel for summarizing data without formulas. The screen below shows the how fields have been configured to build the pivot table shown above. Pivot tables automatically group data using field values. For more details and examples, seeExcel Pivot Tables.

Pivot tables are an easy way to quickly count values in a data set. In the example shown, a pivot table is used to count the names associated with each color. Fields The pivot table shown is based on two fields: Name and Color. Steps Notes

Pivot tables make it easy to quickly sum values in various ways. In the example shown, a pivot table is used to sum amounts by color. Fields The pivot table shown is based on two fields:ColorandAmount. Steps Notes

Standard Pivot Tables have a simple feature for creating calculated fields. you’re free to think of a calculated field as a virtual column in the source data. The pivot table displays the calculated unit price for each product in the source data. A fourth field called “Unit Price” is a calculated field.

Standard Pivot Tables have a simple feature for creating calculated items. you could think of a calculated item as “virtual rows” in the source data. A calculated item will not appear in the field list window. Instead, it will appear as an item in the field for which it is defined. The pivot table displays the correct regional totals, including the new region “Southeast”. Fields The source data contains three fields: Date, Region, and Sales....

In the example shown, there are two rules applied. The best option is to set up the rule correctly from the start. you’ve got the option to access existing rules at Home > Conditional Formatting > Manage Rules. Then adjust tweaks in the “Apply rule to” section. Note: conditional formatting is lost when you remove the target field from a pivot table.

Pivot tables can group dates by year, month, and quarter. In the example shown, there are 100 names and birthdays in the source data. A pivot table is used to count the birthdays that occur in each month of the year. Fields The source data contains two fields:Name, andBirthdate. Then add the Month field to the pivot table directly. Steps Notes

A pivot table is an easy way to count blank values in a data set. Fields The pivot table shown is based on three fields: First, Last, and Department. Any text field in the data that is guaranteed to have data can be used to calculate count. Steps Notes

Pivot tables have a built-in feature to group dates by year, month, and quarter. The count displayed represents the number of records per month for each color. Fields The source data contains three fields:Date,Sales, andColor. Only two fields are used to create the pivot table:DateandColor. TheColorfield has been added as a Row field to group data by color. Then add the Year field to the pivot table directly. Steps Notes

Pivot tables have a built-in feature to group dates by year, month, and quarter. In the example shown, a pivot table is used to count colors per year. This is the number of records that occur for each color in a given year. Fields The source data contains three fields: Date, Sales, and Color. Only two fields are used to create the pivot table: Date and Color. The Color field has been added as a Row field to group data by color....

The pivot table shows the count of employees in each department along with a percentage breakdown. Fields The pivot table shown is based on two fields:DepartmentandLast.

When a filter is applied to a Pivot Table, you may see rows or columns disappear. This is because pivot tables, by default, display only items that contain data. In the example shown, a filter has been applied to exclude the East region. you’re able to use the same approach, with a few extra steps,described here.