Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Line Chart: Switch X and Y Axes the Right WayIn Excel, a line chart’s Switch Row/Column command changes which data series are plotted; it does not literally exchange the horizontal and…
- Excel Line Chart Rising Line: How to Remove ItTo remove a rising line in an Excel line chart, first identify what the line represents: select the chart line and press…
- Excel Line Chart Not Showing All Data? How to Fix ItIf an Excel line chart is not showing all your data, first check the chart’s source range and filters, then inspect hidden…
- Excel Line Chart Not Showing a Line? Fix ItIf an Excel line chart is not showing a line, first check that the chart has a numeric data series, that the…
- Excel Line Chart Overlapping Lines? Causes and FixesIf lines overlap in an Excel line chart, first check whether the plotted values are identical or simply too close to distinguish;…
- Excel Line Chart: Ignore Null Values or Show GapsYes. In Excel for Microsoft 365 on Windows, you can control how a line chart handles empty cells: show a gap, plot…
- Excel Line Chart: How to Ignore Zero Values in a ChartYes. To make an Excel line chart ignore numeric zeros, create a helper column that returns NA() for zero values, then chart…
- Excel Line Chart Not Plotting Correctly? Fix the DataIf an Excel line chart is missing points, plotting the wrong values, or showing an unexpected axis, first check its source range…
- Excel Line Chart Blanks: Gaps, Zeros, or Connected LinesYes. In Excel for Microsoft 365 on Windows, you can choose whether blank cells in a line chart appear as gaps, are…
- Excel Line Charts: Ignore Blank Cells or Show Gaps?Yes. In Excel for Microsoft 365 on Windows, select the line chart, choose Chart Design > Select Data > Hidden and Empty…
- Excel Line Chart: Hide Zero Values Without Losing DataTo hide zero values in an Excel line chart without changing your original data, create a helper column that replaces zeros with…
- Excel Line Chart Examples: How to Choose and FormatExcel line chart examples include monthly sales trends, several product lines compared over time, actual results against a target, and daily measurements…
- Excel Line Chart: How to Fill Gaps in Missing DataIn Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Select Data > Hidden and Empty Cells…
- Excel Line Chart Zero Values: What to ChangeExcel plots a numeric zero as a real data point, so a line chart will show it on the zero line unless…
- Excel Line Chart Comparing Two Years: A Clear SetupTo make an Excel line chart comparing two years, put the shared time periods in the first column and each year’s values…
- Excel Line Chart: How to Connect GapsTo connect gaps in an Excel line chart, select the chart and choose Chart Design > Select Data > Hidden and Empty…
- Excel Line Chart Data Range: How to Set ItIn Excel for Microsoft 365 on Windows, select the cells you want to chart—including the category labels and series headings—then choose Insert…
- Excel Line Chart by Date: Make Dates Plot CorrectlyTo make an Excel line chart by date, put real Excel dates in one column and the values to chart beside them,…
- Excel Line Chart: Change X-Axis ValuesTo change the x-axis labels on an Excel line chart, select the chart, choose Chart Design > Select Data, then under Horizontal…
- Excel Line Chart: Change Color Partway Through a LineTo change a line chart’s color partway through in Excel for Microsoft 365 on Windows, split the plotted values into two helper…
- Excel Line Chart: How to Add a Vertical Reference LineTo add a vertical line to an Excel line chart, use Insert > Shapes > Line for a quick visual marker, or…
- Excel Line Chart with Two Lines: Setup, Labels, and FixesTo make an Excel line chart with two lines, arrange the shared category labels in one column and each data series in…
- Excel Legend Order Wrong on Combo Charts? Fix ItTo fix a wrong legend order on an Excel combo chart, select the chart, choose Chart Design > Select Data, then select…
- Excel Waterfall Chart Totals: How to Add and FormatTo show a total in an Excel waterfall chart, right-click the bar that represents the total and choose Set as Total. To…
- Excel Horizontal Waterfall Chart: How to Build OneExcel does not provide a horizontal orientation for its built-in Waterfall chart: the native chart displays changes as vertical columns. To make…
- Excel Histogram With a Line Chart: How to Build OneYes. In Excel for Microsoft 365 on Windows, the most dependable way to put a line on a histogram is to summarize…
- Excel Histogram: How to Set the Number of Bins ExactlyIn Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, open Format Axis, and under Axis Options set Bins to…
- Excel Histogram Tutorial: Create and Customize ChartsTo make a histogram in Microsoft Excel for Microsoft 365 on Windows, select the numeric data, then choose Insert > Insert Statistic…
- Excel Histogram: Show Percentages Instead of CountsExcel’s built-in Histogram chart displays counts, not the percentage of observations in each bin. To show percentages, calculate each bin’s relative frequency…
- Excel Histogram: Change the Number of Bins or Bin WidthTo change an Excel histogram’s bin count in Microsoft 365 for Windows, click the chart’s horizontal axis, right-click and choose Format Axis,…