I love the new Pivot Chart feature on Excel 2016 for Mac. However sometimes I would like to Switch Rows and Columns on the chart without affecting the pivot table. For instance, in a pivot table where amounts are organised on a horizontal timeline, if I try to do a line chart, I.
This Excel tutorial explains how to show the top 10 results in a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, how do I show only the top 10 results in a pivot table?
Answer: In this example, we want to show the top 10 Order IDs based on the 'Sum of Quantity'.
IMPORTANT: Please note that 'Top 10 functionality' in Excel 2011 for Mac works differently than the Windows Excel versions (ie: Excel 2010, 2007, 2003, etc). In Excel 2011 for Mac, the Top 10 will return the lowest 10 'Sum of Quantity' values. If you wish to retrieve the highest 10 'Sum of Quantity' values, you will need to use the Bottom 10 solution.
Click on the arrow to the right of the Order ID drop down box.
A popup window will appear. In this window, click on By value and select Top 10 from the popup menu.
'Top 10' should appear in the window, replacing the 'By value' drop down. Next, enter 10 in the field directly below to specify that you wish to see the top 10 items.
Then close this popup by clicking on the X in the top left of the popup.
Now when you view your spreadsheet, you should only see the top 10 Order IDs based on the Sum of Quantity.
Jump to Excel for Mac
Jump to Excel for PC
Jump to Excel for PC
Excel for Mac
Basic Excel for Mac
- Cells, columns, and rows
- Cut, copy, and paste
- Basic formulas and autosum
- Sorting
- Formatting
- Getting ready to print
Basic Excel for Mac Tutorial Videos:
Data Crunching Tool and Tips for Mac
- Import Data from a Text File
- Filters
- Relative vs Absolute Cell References
- Text To Columns Command
- Handout contains information on the above subjects plus Functions, Subtotals, and Conditional Formatting
Data Crunching Tutorial Videos for Mac:
- Importing Data from a Text File Take data from a .txt or .csv and bring it into Excel.Here's a practice .csv file.
- Using FiltersEasily and quickly sort your data or view records for only certain criteria.
- Relative and Absolute Cell References Choose whether the cells a formula refers to move when it moves, or stay fixed in place.
- 'Text to Columns' Command Take data in a cell and split it out into multiple cells. Turn 'John Smith' into 'John' 'Smith'.
- Subtotals Automatically add subtotals to your spreadsheet.
- 'Concatenate' Function Take data in multiple cells and combine it in one cell. Turn 'John' 'Smith' into 'John Smith'.
Pivot Tables for Mac
- Create a pivot table to summarize your data automatically.
- Re-arrange that pivot table for different views of your data or to add additional criteria.
- Learn more advanced options, such as adding column labels and grouping.
- Format your pivot table, and learn some options for sharing or duplicating it.
Pivot Tables Tutorial Videos for Mac:
- Get started Create your pivot table.
- Refine or re-define your table Use filters and sorting, add a secondary criterion, display values as percentages.
- Advanced options Add column labels, groups, report-wide filters.
- Final steps Format numbers, pick a color scheme, copy a pivot table, 'paste special' to paste values only.
Click here to view the YouTube playlist of all these videos, or preview them below.
Charts in Excel for Mac
- Create a chart using a table of data.
- Customize the formatting and what information shows where.
- Learn more advanced options, such as adding a secondary axis and customizing axis labels.
- Pick a color scheme: then move, copy, or print your chart.
Charts Tutorial Videos for Mac:
- Create Your Chart - Pick a chart type, learn about the different chart elements, and find out what Excel puts where.
- Formatting In this segment, we cover formatting and tweaking your existing chart and its elements.
- Advanced options Create a secondary axis, and fix your chart when Excel makes 'wrong guesses' about layout.
- Final steps Pick a color scheme and style visual elements, and move or copy your chart to a new sheet or another document.
Excel for PC
Basic Excel for PC
- Cells, columns, and rows
- Cut, copy, and paste
- Basic formulas and autosum
- Sorting
- Formatting
- Getting ready to print
Basic Tutorial Videos for PC:
Data Crunching Tool and Tips for PC
- Import Data from a Text File
- Filters
- Relative vs Absolute Cell References
- Text To Columns Command
- Handout contains information on the above subjects plus Functions, Subtotals, and Conditional Formatting
Data Crunching Tutorial Videos for PC:
- Importing Data from a Text File Take data from a .txt or .csv and bring it into Excel, and have it look nice!Here's a practice .csv file.
- Using FiltersEasily and quickly sort your data or view records for only certain criteria.
- Relative and Absolute Cell References Choose whether the cells a formula refers to move when it moves, or stay fixed in place.
- 'Text to Columns' Command Take data in a cell and split it out into multiple cells. Turn 'John Smith' into 'John' 'Smith'.
- Subtotals Automatically add subtotals to your spreadsheet.
- 'Concatenate' Function Take data in multiple cells and combine it in one cell. Turn 'John' 'Smith' into 'John Smith'.
Pivot Tables for PC
- Create a pivot table to automatically summarize your data.
- Re-arrange that pivot table for different views of your data or to add additional criteria.
- Learn more advanced options, such as adding column labels and grouping.
- Format your pivot table, and learn some options for sharing or duplicating it.
Pivot Tables Tutorial Videos for PC:
- Get started Create your pivot table.
- Refine or re-define your table Use filters and sorting, add a secondary criterion, display values as percentages.
- Advanced options Add column labels, groups, report-wide filters.
- Slicers A new feature in Office 2010 that lets you quickly filter data. (Video by Microsoft.)
- Final steps Format numbers, pick a color scheme, copy a pivot table, 'paste special' to paste values only.
Charts in Excel for PC
- Create a chart from a data table.
- Format your chart with an eye toward ease of understanding.
- Add more advanced options like a secondary axis, learn more about changing how a chart displays information.
- Give your chart some finishing visual touches, then print it or use it in another document.
Charts Tutorial Videos for PC:
- Create Your Chart Pick a chart type, learn about the different chart elements, and find out what Excel puts where.
- Formatting In this segment, we cover formatting and tweaking your existing chart and its elements.
- Advanced Options Create a secondary axis, and fix your chart when Excel makes 'wrong guesses' about layout.
- Final Steps Pick a color scheme and style visual elements, and move or copy your chart to a new sheet or another document.