Charts & pivot tables
Build, format and fix charts and pivot tables.
- Keep the Same Dates Visible in an Excel Column ChartTo keep every source date visible on an Excel column chart, set the horizontal category axis to Text axis and format its…
- Insert an Excel Graph Into Word and Keep It UpdatedTo insert an Excel graph into a Word document, select the chart in Excel, copy it, then paste it into Word and…
- How to Insert an Excel Chart Into PowerPoint EasilyTo insert an Excel chart into PowerPoint, select the chart’s outer border in Excel and press Ctrl+C, then open the slide and…
- How to Insert an Excel Chart Into WordTo insert an Excel chart into Word, select the chart in Excel, copy it, click where it should appear in Word, and…
- How to Insert an Excel Chart in CanvaTo insert an Excel chart in Canva, save the chart from Excel as a PNG image, then upload that file in Canva…
- How to Insert an Excel Chart Into AutoCADTo insert an Excel chart into AutoCAD on Windows, copy the chart in Excel, switch to AutoCAD, run PASTESPEC, choose the Microsoft…
- How to Insert an Average Line in an Excel ChartTo insert an average line in an Excel chart, calculate the average in a helper column, repeat that value beside each chart…
- How to Insert a Clustered Column Chart in ExcelTo insert a clustered column chart in Microsoft Excel for Microsoft 365 on Windows, arrange your categories in the first column and…
- How to Hide the Number Axis in an Excel Pareto ChartTo hide the numbers on an Excel Pareto chart without removing its bars or cumulative-percentage line, select the number axis, open Format…
- How to Flip an Axis in an Excel Chart: Step-by-Step GuideTo flip an axis in an Excel chart, select the axis, right-click it, choose Format Axis, and turn on Categories in reverse…
- How to Find Slope in an Excel GraphTo find the slope in an Excel graph, add a linear trendline and display its equation, or calculate the slope directly with…
- Fill Area in an Excel Chart: A Practical Step-by-StepTo fill an area in an Excel chart, select the data series, right-click it, choose Format Data Series, then open Fill &…
- How to Edit a Clustered Column Chart in ExcelTo edit a clustered column chart in Excel, select the chart and use the Chart Design or Format tab to change its…
- How to Edit the Chart Area in ExcelTo edit a chart area in Excel, select the chart, open the contextual Format tab, choose Chart Area from Current Selection, then…
- How to Edit an Org Chart in Excel: Steps and FixesTo edit an org chart in Excel, click a box and change its text, or select the chart and use SmartArt Design…
- How to Edit a Stacked Bar Chart in ExcelTo edit a stacked bar chart in Excel, select the chart and use the Chart Design and Format tabs to change its…
- How to Draw a Radar Chart in Excel: A Step-by-Step GuideTo draw a radar chart in Microsoft Excel, arrange your categories in the first column and each data series in its own…
- Stacked Area Chart in Excel: Create and Format OneTo make a stacked area chart in Excel, arrange your time periods in the first column and each data series in its…
- How to Delete a Graph in Excel Without Removing DataTo delete a graph (chart) in Excel without deleting the information behind it, click the chart’s outer border until the whole chart…
- Create a P Chart in Excel: Step-by-Step GuideTo create a p chart in Excel, list each subgroup’s sample size and count of nonconforming units, calculate the subgroup proportions and…
- How to Create a Stacked Column Chart in ExcelTo create a stacked column chart in Excel, arrange categories in the first column and each data series in its own column,…
- How to Create a Sunburst Chart in Excel: Step-by-StepTo create a Sunburst chart in Microsoft Excel for Microsoft 365, arrange your data in columns from the broadest category to the…
- Treemap Chart in Excel: How to Create One Step by StepTo create a treemap chart in Excel for Microsoft 365 on Windows, arrange your data in hierarchy columns with a numeric value…
- Gantt Chart in Excel: Build a Project ScheduleCreate a Gantt chart schedule in Excel by listing tasks, start dates, and durations, then inserting a 2-D stacked bar chart. Hide…
- How to Create a Chart Audit Form in Excel: Step by StepCreate a chart audit form in Excel by listing each audit as one row, adding consistent Yes/No/N/A fields for chart criteria, and…
- Copy Graph Format in Excel: Step-by-Step InstructionsTo copy a graph’s appearance in Excel for Microsoft 365 on Windows, select the source chart, choose Home > Format Painter, and…
- How to Copy and Paste a Graph in ExcelTo copy and paste a graph (called a chart in Excel), select its outer border, press Ctrl+C, click where you want the…
- How to Copy a Graph in Excel: Steps and OptionsTo copy a graph (called a chart in Excel), click its outer border, press Ctrl+C, click where you want the copy, and…
- How to Combine Pie Charts in Excel: A Practical GuideTo combine pie charts in Excel into one chart, first combine their source data into a single list of categories and totals,…
- Close the Gap Between Bars in an Excel ChartTo close the gap between bars in an Excel chart, select a bar, open Format Data Series, and set Gap Width to…