Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Bar Graph: Count Occurrences and Chart ResultsTo count how often each category appears in Excel and show the totals in a bar graph, make a list of categories,…
- Excel Pivot Table Median Instead of AverageYes—but a standard Excel PivotTable cannot choose Median in its usual Value Field Settings list. In Excel for Microsoft 365 on Windows,…
- Excel Pivot Table Mode: Find the Most Common ValueTo find a mode with an Excel PivotTable, put the field you want to analyze in both Rows and Values, set the…
- Excel Not Making Graphs Correctly? Fix Common CausesIf Excel is not making graphs correctly, first check that the chart uses the intended data range, treats the first row or…
- Excel pivot table group by month?Group Excel PivotTable dates into months, keep years distinct, fix grouping errors, and choose a helper-field alternative for clearer reports.