Charts & pivot tables
Build, format and fix charts and pivot tables.
- 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…
- Excel Chart Ignore Blank Cells? How to Control GapsYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data > Hidden and Empty Cells,…
- Excel Chart Labels: Add, Format, and Fix ThemIn Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart Element > Data Labels and…
- Excel Chart Legend Missing Series? How to Fix ItIf an Excel chart legend is missing a series, select the chart and open Chart Design > Select Data to check whether…
- Excel Chart Horizontal Axis Labels: How to Set ThemIn Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, then under Horizontal (Category) Axis Labels…
- Excel Chart Group by Category: How to Set It Up RightTo group Excel chart data by category, first summarize the records so each category has one row, then chart that summary. In…
- Excel Chart Format Code for Millions: Examples and TipsTo show Excel chart values in millions, apply the custom number format #,##0,,"M"; for one decimal place, use 0.0,,"M". In a chart,…
- Excel Chart Elements: What They Are and How to Use ThemExcel chart elements are the visual parts that explain, organize, or add detail to a chart, such as its title, axes, legend,…
- Excel Chart Error Bars: How to Add and Customize ThemExcel chart error bars show the amount of uncertainty, variation, or measurement range associated with plotted values. In Microsoft Excel for Microsoft…
- Excel Chart Filter: How to Show or Hide DataAn Excel chart filter lets you show or hide selected data series or categories without changing the chart’s source data. In Excel…
- Excel Chart Design: Choose and Improve the Right ChartExcel chart design means choosing a chart that fits the question, arranging the data so Excel can interpret it correctly, and formatting…
- Excel Chart Not Plotting Zero Values? How to Fix ItExcel normally plots numeric zero values, but a zero can be hard to see: a zero-height column has no visible bar, and…
- Excel Chart Dynamic Title: Link It to a CellTo make an Excel chart title dynamic in Microsoft 365 for Windows, put the title text or a formula in a worksheet…
- Excel Chart Dates Not Matching Data? Fix the AxisIf Excel chart dates do not line up with the source data, first check whether the date cells contain real Excel dates…
- Excel Chart Data Labels in Millions: Number FormatTo show Excel chart data labels in millions, select the labels, open Format Data Labels, then under Number enter #,##0.0,,"M" in Format…
- Excel Chart Conditional Formatting: Rules and WorkaroundsExcel charts do not automatically inherit conditional formatting from their source cells. To make chart colors respond to a rule, create separate…
- Excel Cumulative Line Graph: How to Create OneTo make a cumulative line graph in Excel, add a running-total column beside your values, then chart the dates or categories against…
- Excel Chart Series Name: Change It and Fix Series LabelsTo change an Excel chart series name in Microsoft 365 for Windows, select the chart, choose Chart Design > Select Data, select…
- Excel Chart Color Based on Value: How to Set It UpYes. In Excel for Microsoft 365 on Windows, the most reliable way to color chart points according to their values is to…
- Excel Chart Axis Range: Set Minimum and Maximum ValuesTo change an Excel chart’s numeric axis range in Microsoft 365 for Windows, select the chart axis, right-click it, choose Format Axis,…
- Excel Chart Legend Text: Rename Series and Edit LabelsTo change legend text in an Excel chart, select the chart, choose Chart Design > Select Data, select the series under Legend…
- Excel Chart: How to Change Bar OrderTo change the order of bars in an Excel chart, either sort the chart’s source data, reverse the category axis, or change…
- Excel Chart Average Line: Add and Format the MeanTo add an average line to an Excel chart, calculate the mean in a worksheet cell, repeat that value in a helper…
- Excel Chart Axis in Millions: Format Values ClearlyTo show an Excel chart axis in millions, select the axis, open Format Axis, and either choose Millions under Axis Options >…
- Excel Chart Series Order: Bring a Data Series to FrontYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, select the series under Legend…
- Excel Chart Axis Range: Set Minimum and Maximum ValuesTo adjust an Excel chart’s axis range, select the value axis, open Format Axis, and enter new values under Axis Options >…
- Excel Chart: Add a Data Label to the Last PointTo label only the last point in an Excel chart, click the data series once, click its final point again to select…
- Excel Chart: How to Add, Move, and Customize a LegendTo add a legend in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element…
- Excel Chart: Add a Vertical Line at a DateTo add a vertical line at a date in an Excel chart, create a helper series with the target date listed twice…
- Vertical Bullet Chart in Excel: Build One Step by StepTo create a vertical bullet chart in Excel, make a stacked column chart from your performance-range bands, place a transparent actual-value column…