Charts & pivot tables
Build, format and fix charts and pivot tables.
- Pareto Chart in Excel: Create and Read One Step by StepTo make a reliable Pareto chart in Excel for Microsoft 365 on Windows, summarize your categories and counts, sort the counts from…
- Matrix Bubble Chart in Excel: How to Build and Format OneYes. In Excel for Microsoft 365 on Windows, put each item’s numeric X position, numeric Y position, and bubble size in separate…
- Map Bubble Chart in Excel: Build and Format One EasilyExcel does not combine its standard Filled Map chart with bubble-size markers in one chart type. In Excel for Microsoft 365 on…
- How to Make a Stacked Bar Chart in ExcelTo make a stacked bar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each part…
- Making a Pareto Chart in Excel: Steps and TipsTo make a Pareto chart in Excel for Microsoft 365 on Windows, select a column of raw category observations and choose Insert…
- Radar Chart in Excel: How to Create and Format OneTo make a radar chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data…
- KPI Dashboard Excel Template: Free Tutorial for BeginnersYou can build a free KPI dashboard in Excel by turning a tidy data range into a table, calculating a few clearly…
- KPI Dashboard Excel Template: Free ExamplesFree KPI dashboard Excel templates are available through sources such as Microsoft Create and Excel’s File > New template gallery, although the…
- KPI Chart in Excel: Build, Format, and Track PerformanceExcel does not have a standalone chart type called “KPI chart,” but you can make one by charting a key measure against…
- How to Wrap Data Labels in an Excel ChartTo wrap data labels in an Excel chart, put a line break in the text you want displayed, then use that text…
- How to Shuffle Bars in Excel Graphs into Random OrderTo shuffle bars in an Excel graph into a random order, add a helper column with =RAND(), replace the generated numbers with…
- How to Show a Forecast in an Excel ChartTo show a forecast in Excel for Microsoft 365 on Windows, put dates and values in two columns, select the data, and…
- How to Set Up Data for a Sunburst Chart in ExcelTo set up data for a Sunburst chart in Excel, put each level of the hierarchy in its own column, list one…
- How to Save an Excel Chart as a Template in Excel 365To save an Excel chart as a reusable template in Microsoft 365 for Windows, select or right-click the chart, choose Save as…
- How to Save a Graph in Excel as a Picture: PNG or JPGTo save a graph (which Excel calls a chart) as an image in Microsoft Excel for Microsoft 365 on Windows, right-click the…
- How to Save an Excel Chart as a Picture in High QualityIn Excel for Microsoft 365 on Windows, right-click the chart, choose Save as Picture, select a file type such as PNG, and…
- How to Round Data Labels in an Excel ChartTo round numbers shown on an Excel chart without changing the underlying data, select the chart’s data labels, press Ctrl+1, open Number…
- How to Rotate Data Labels in Excel Charts: A Practical GuideTo rotate data labels in an Excel chart, select the labels, open the Format Data Labels pane, then choose Text Options >…
- How to Rotate an Excel Graph in WordTo rotate an Excel graph in Word, copy it and paste it as a picture, then select the picture and choose Picture…
- How to Reverse Order in Excel Graphs: Axis and SeriesTo reverse the order of categories in an Excel graph, select the chart axis, open Format Axis, and turn on Categories in…
- Reverse Horizontal Axis in Excel Chart: Step-by-StepTo reverse a chart’s horizontal axis in Excel for Microsoft 365 on Windows, right-click the axis, choose Format Axis, open Axis Options,…
- How to Rename a Legend in an Excel Pie ChartTo rename a legend item in an Excel pie chart, change the category name in the worksheet cell that supplies the chart’s…
- How to Rename Series in an Excel Chart: Steps and TipsTo rename a series in an Excel chart, select the chart, go to Chart Design > Select Data, choose the series under…
- Rename Data Series in an Excel Chart: A Clear GuideTo rename a data series in an Excel chart, select the chart, choose Chart Design > Select Data, select the series under…
- How to Rename a Legend in an Excel ChartTo rename a legend entry in an Excel chart, select the chart, go to Chart Design > Select Data, choose the series…
- How to Put Subscript in an Excel Graph Axis LabelsTo put a subscript in an Excel graph axis title, select the title text, highlight the character or characters to lower, open…
- Subscript in Excel Legend: Use Unicode or Rich TextTo put a subscript in an Excel chart legend, either use a Unicode subscript character in the series name, such as the…
- How to Put an Average Line in an Excel Chart EasilyTo put an average line in an Excel chart, calculate the average in a helper column, repeat that value beside each data…
- How to Print an Excel Graph on a Full Page in ExcelTo print an Excel graph across a full page, select the chart, choose Chart Design > Move Chart > New sheet, then…
- How to Make an XY Chart in Excel: Step-by-Step GuideTo make an XY chart in Excel, put your X values in one column and the matching Y values in the next,…