Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Line Chart in a Cell: Create and Format SparklinesTo put a line chart inside an Excel cell, insert a Line Sparkline: select the destination cell, choose Insert > Sparklines >…
- KPI Chart in Excel Using a Pivot Table: Setup and TipsTo make a KPI chart in Excel, summarize your source data in a PivotTable, insert a PivotChart, and compare the result with…
- Insert a Combo Chart in Excel: Steps, Axes, and TipsTo insert a combo chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Combo Chart…
- How to Rotate a Waterfall Chart in Excel: Axis OptionsTo change the way a waterfall chart reads in Excel, format its category axis: reverse the category order or angle the category…
- How to Make a Waterfall Chart in ExcelTo make a waterfall chart in Excel, arrange your categories and positive or negative changes in two columns, select the data, then…
- How to Plot a Waterfall Chart in Excel Step by StepTo plot a waterfall chart in Excel, arrange your categories in one column and the changes in value in the next, select…
- How to Prepare a Waterfall Chart in Excel Step by StepTo prepare a waterfall chart in Microsoft Excel for Microsoft 365 on Windows, put each step in a category column and its…
- How to Manually Sort the X-Axis in an Excel Pivot ChartTo manually sort a PivotChart’s x-axis in Excel for Microsoft 365 on Windows, reorder the category items in the PivotTable that feeds…
- JMP Pivot Chart: How to Create One Step by StepTo make a pivot chart in JMP, reshape and summarize your source data with Tables > Pivot, then open Graph > Graph…
- How to Insert a Combo Pivot Chart in Excel: WorkaroundExcel for Microsoft 365 on Windows does not let you combine chart types in a true PivotChart. To make the equivalent of…
- How to Keep Pivot Chart Formatting in Excel After RefreshTo keep a PivotChart looking consistent in Excel, finish arranging the PivotTable fields first, format the chart, and avoid changing its structure…
- How to Create a Waterfall Chart in ExcelTo create a waterfall chart in Excel, arrange your categories and positive or negative changes in two columns, select the data, then…
- How to Format Data for a Combo Chart in ExcelTo format data for an Excel combo chart, put category labels in the first column, give each data series its own column…
- Create a Custom Combo Chart in ExcelTo create a custom combo chart in Excel for Microsoft 365 on Windows, select your category labels and data series, then choose…
- How to Change the Key on a Pie Chart in Excel Step by StepTo change the key, or legend labels, on a pie chart in Excel, edit the category names in the worksheet cells that…
- How to Adjust Histogram X-Values in ExcelTo adjust a histogram’s x-values in Excel for Microsoft 365 on Windows, select the horizontal axis, open Format Axis, and change the…
- How to Build a Combo Chart in Excel with a Secondary AxisTo build a combo chart in Excel, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign…
- How to Add a Combo Chart in Excel: A Clear WalkthroughTo add a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All…
- Histogram in Excel Without ToolPak: A Step-by-Step GuideYes. You can make a histogram in Excel for Microsoft 365 without the Analysis ToolPak: select your numeric data and use Insert…
- Histogram in Excel Using Formulas: Build Bins and ChartsTo make a histogram in Excel with formulas, list your data, set bin limits, and use FREQUENCY to count values in each…
- Histogram in Excel: Step-by-Step GuideTo make a histogram in Excel for Microsoft 365 on Windows, put your numeric observations in one column, select the data, then…
- How to Hide Zeros in an Excel Pivot Chart ProperlyIn Excel for Microsoft 365 on Windows, the right way to hide zeros in a PivotChart depends on what you mean: apply…
- Google Sheets Dashboard Creation: Build a Useful DashboardTo create a dashboard in Google Sheets, organize your source data in a clean table, summarize it with formulas or pivot tables,…
- Format Waterfall Charts in Excel: A Practical GuideTo format a waterfall chart in Excel for Microsoft 365 on Windows, select the chart and use the Chart Design and Format…
- Filter in Power Pivot: Ways to Narrow PivotTable DataTo filter Power Pivot data, add the Data Model to a PivotTable and use its field drop-downs, report filters, slicers, or timelines.…
- Explode Pie Chart in Excel: Steps and Formatting TipsTo explode a pie chart in Excel, select the chart, select the slice you want to move, open Format Data Point, and…
- Excel Waterfall Combo Charts: Setup and WorkaroundsYes—but Excel’s built-in Waterfall chart cannot be combined directly with another chart type in the standard Combo chart setup. In Microsoft 365…
- Excel Waterfall Chart Tutorial: Build and Format OneTo make a waterfall chart in Excel for Microsoft 365 on Windows, put category labels in one column and the amounts that…
- Excel Waterfall Chart With Two Series: What WorksNo: Excel’s built-in Waterfall chart plots one data series at a time, so it cannot show two independent series as parallel waterfall…
- Excel Waterfall Chart X-Axis Labels: How to Wrap TextYes. In Excel for Microsoft 365 on Windows, the reliable way to wrap text on a waterfall chart’s x-axis is to put…