Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Bar Graph Too Skinny? Fix Bar Width and SpacingIf an Excel bar graph looks too skinny, select a bar, open Format Data Series, and reduce Gap Width under Series Options.…
- Excel Bar Over Bar Graph: How to Overlay Two Data SeriesTo put one data series over another in an Excel bar chart, select a bar, open Format Data Series, and set Series…
- Excel Bar Graph: Sort Values Largest to SmallestTo sort an Excel bar graph from largest to smallest, sort the chart’s source data by its value column: select a cell…
- Excel Bar Graph Creation: Steps, Tips, and FixesTo create a bar graph in Excel for Microsoft 365 on Windows, select a labeled data range, then choose Insert > Insert…
- Excel Bar Graph Grouping: Create Clustered BarsTo group bars in Excel, arrange each group as a separate data series, select the category labels and values, then choose Insert…
- Excel Bar Graph Not Showing All Data? Fix ItIf an Excel bar graph is missing bars or categories, first check its source range in Chart Design > Select Data, then…
- Excel Bar Graph Conditional Formatting: Color by RulesExcel does not apply worksheet conditional formatting rules directly to the bars in a chart. To make bar colors change automatically with…
- 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.