Subtotal and total fields in a PivotTable - Microsoft Support
When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the subtotals and grand totals with or without filtered items.
Show or hide subtotals and totals in a PivotTable - Microsoft …
Click Design > Subtotals. Pick the option you want: Do Not Show Subtotals. Show all Subtotals at Bottom of Group. Show all Subtotals at Top of Group. Tips: To include filtered items in the total amounts: Click Include Filtered Items in Totals. Click this option again to turn it off.
Change the plotting order of categories, values, or data series
Reverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
Design the layout and format of a PivotTable - Microsoft Support
Select the row or column label item that you want to move, and then point to the bottom border of the cell. When the pointer becomes a four-headed pointer, drag the item to a new position. The following illustration shows how to move a row item by dragging.
Outline (group) data in a worksheet - Microsoft Support
Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols. Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group.
Filter data in a PivotTable - Microsoft Support
You can also apply filters to show the top or bottom 10 values or data that meets the certain conditions. In the PivotTable, click the arrow next to Row Labels or Column Labels . Right-click an item in the selection, and then click Filter > Top 10 or Bottom 10 .
Change the display of chart axes - Microsoft Support
Value axes provide a variety of options, such as setting the scale to logarithmic. Other chart types, such as column, line, and area charts, show numeric values on the vertical (value) axis only and show textual groupings (or categories) on the horizontal axis.
Add and format a chart legend - Microsoft Support
To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options , and then make the format changes that you want. Depending on the chart type, some options may not be available.
Edit titles or data labels in a chart - Microsoft Support
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
Sort data in a range or table - Microsoft Support
To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting. Check out the video to see how it's done. Windows Web. If your data isn't already in a table, then format it as a table.
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.