The only difference is you have two different categories: the axis and the legend.Ĭhanging Field Settings for Pivot Tables and Pivot Charts Now you can organize your pivot chart just as you did a pivot table. Next, select if you want it in a new or existing worksheet. We're going to just create a pivot chart. Select if you want to create just a pivot chart – or a pivot chart and table. You can also create a pivot chart from a table.Ĭlick the Pivot Chart button under the Insert tab. Otherwise, Excel will only create the pivot table/chart up to the blank row or column. Tip: Make sure there aren't blank rows or columns before you begin. The totals in the pivot table reflect both salaries. Let's amend the chart to show you what we mean by adding another Account Manager.Īs you can see, we added another Account Manager to our table. If we had more than one salary per job description, it would total the salaries for us. Now we can see the salary by department and by job description. We want the values shown in the table to be salary, so we will drag and drop that to Values. We want Position to be a Row Header, so we drag and drop to Row Labels. Let's create a pivot table using the table above. Here's a better example because it shows you what a pivot table can do with your data. You can add a filter for any category: First Name, Last Name, or Phone number (in the case of our table). We can also use the filter we created at the top to select a phone number to find out who it belongs to. Now we can see how many phone numbers we had for each person. Here's what we've done in the Field list on the right: You can always drag and drop to a different section if you want. Your pivot table will appear in your spreadsheet as you do this. Just drag and drop from the top part of the field list to the bottom part and place it in a category: Filters, Columns, Rows, and Values. If you look at your Pivot Table Field list on the right, you can drag and drop from the "Choose Fields to Add to Report" section down to the "Drag Fields Between Areas Below" section. This is what you should now see on your screen: The name field in our table would be arbitrary. In ours, that's the salaries.Īrbitrary fields are fields that are neither data or category. In ours, we grouped category fields by department and position.ĭata fields are fields that contain data that you can add, subtract, multiply, or divide. This is a list of all fields in your table.Ĭategory fields are fields that you can group. On the right, you'll see the Field list open up. To do this, select the table, then go to the Insert tab and click Pivot table. We want a pivot table showing us how many phone numbers are on file for each employee.
In tables, columns are fields and rows are records.
PIVOT TABLES IN EXCEL 2013 HOW TO
The best way to learn about a pivot table is to see how to create one.
0 kommentar(er)
