Charts & pivot tables
Build, format and fix charts and pivot tables.
- Pivot Chart Secondary Axis: How to Add and Format OneYes. In Excel for Microsoft 365 on Windows, select the PivotChart series you want to rescale, open Format Data Series, and under…
- Excel Pivot Table Row Labels: How to Change the HeaderIn Excel for Microsoft 365 on Windows, click the PivotTable cell that says Row Labels, type the heading you want, and press…
- Excel Chart Won’t Update With New Data? Causes and FixesIf an Excel chart will not update with new data, first check whether its source range includes the new cells: select the…
- Excel Pivot Table: How to Change the Data SourceTo change an Excel PivotTable’s source in Microsoft 365 for Windows, click inside the PivotTable, select PivotTable Analyze > Change Data Source…
- Excel Charts With Dynamic Ranges: Setup and OptionsTo make an Excel chart grow when you add data, convert the source range into an Excel Table, then create the chart…
- Excel Chart With Two Different Scales: How to Make OneYes. In Excel for Microsoft 365 on Windows, put one data series on a secondary axis: select the chart, choose Chart Design…
- Excel Chart Wizard: How Chart Creation Works TodayExcel’s old Chart Wizard is no longer a feature in Microsoft 365 for Windows. To make a chart today, select your data,…
- Excel Chart Title From Cell: Link, Format, and FixesTo link an Excel chart title to a cell, select the chart title, click the formula bar, type =Sheet1!$A$1 using your sheet…
- Excel Chart With Two Y-Axes: How to Make OneTo make an Excel chart with two different y-axis values, select the chart, choose Chart Design > Change Chart Type > Combo,…
- Excel Chart With Drop-Down List: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a drop-down with Data Validation, use a helper column to return the selected…
- Excel Stacked Column Chart with Two SeriesYes. In Excel for Microsoft 365 on Windows, put your category labels in the first column and the two series in the…
- Excel Chart Timeline: Create and Format OneIn Excel for Microsoft 365 on Windows, add a timeline that filters a chart by selecting its PivotTable and choosing PivotTable Analyze…
- Excel Chart Title Formula: Link a Title to a CellTo make an Excel chart title dynamic, select the chart title, click the formula bar, enter a reference to a worksheet cell,…
- Excel Chart Show Hidden Data? How to Control ItYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data > Hidden and Empty Cells,…
- Excel Chart Skip Blank Data? Control Gaps and ZerosYes. In Excel for Microsoft 365, a chart can show blank cells as gaps, treat them as zero, or—on line charts—connect the…
- Excel Chart Slicers: How They Work and How to Add ThemAn Excel chart slicer is a clickable control that filters chart data, so a reader can focus on selected categories without changing…
- Excel Chart: Remove Dates With No Data From the AxisTo remove dates with no data from an Excel chart, select the horizontal axis, open Format Axis, and choose Text axis under…
- Excel Chart Axis Range: Set Minimum and MaximumTo set an Excel chart axis range in Microsoft 365 for Windows, right-click the value axis, choose Format Axis, then under Axis…
- Excel Chart Shortcut: Create a Chart in Seconds on WindowsIn Excel for Microsoft 365 on Windows, select the data you want to chart and press Alt+F1 to insert an embedded chart…
- Excel Chart Not Showing X-Axis Values? How to Fix ItIf an Excel chart is not showing x-axis values, select the chart and check that its horizontal axis is enabled and that…
- Excel Chart Not Updating? Fix the Data Range and RefreshIf an Excel chart is not updating with new data, first check that its source range includes the new cells: select the…
- Excel Chart Overlay: How to Plot Two Data Sets TogetherYes. In Excel for Microsoft 365 on Windows, you can overlay two data sets by adding both as series in one chart:…
- Excel Chart Not Displaying Data Correctly? How to FixIf an Excel chart is skipping, mislabeling, or mis-scaling data, select the chart and check Chart Design > Select Data first: confirm…
- Excel Chart Multiple Series: Add and Format ThemYes. To chart multiple series in Excel for Microsoft 365 on Windows, arrange each series in its own row or column, select…
- Excel Chart Negative Values Below Axis?Yes. In an Excel chart with a vertical value axis, negative numbers normally plot below the horizontal zero line; if they do…
- Excel Chart Legend Icons: How to Make Symbols BiggerYes—Excel can make chart legend icons look bigger, but it does not provide a separate control for setting the legend key’s width…
- Excel Chart: Move the Horizontal Axis to the BottomTo move an Excel chart’s horizontal axis to the bottom, select the vertical value axis, open Format Axis, and set Horizontal axis…
- Excel Chart Maker: Create, Format, and Choose ChartsExcel’s built-in chart maker turns selected worksheet data into a chart: select a well-organized range, then choose Insert > Recommended Charts and…
- Excel Chart Legend Not Showing All Labels?If an Excel chart legend is missing labels, first check what the chart treats as a legend entry: most charts list data…
- Excel Chart Logarithmic Scale: Setup and TroubleshootingTo add a logarithmic scale to an Excel chart in Microsoft 365 for Windows, select the chart’s numeric axis, right-click it, choose…