Charts & pivot tables
Build, format and fix charts and pivot tables.
- Think-Cell Waterfall Chart: How It Works and When to Use ItA think-cell waterfall chart is a PowerPoint chart that shows how a sequence of positive and negative changes moves a starting value…
- Stacked Column Waterfall Chart in Excel: How It WorksYes—you can make a stacked column waterfall chart in Excel, but Excel does not offer a chart type with that exact name.…
- Stacked Waterfall Chart in Excel: How It WorksExcel does not offer a built-in stacked waterfall chart: its native Waterfall chart plots one series, not a stack of component contributions.…
- Stacked Waterfall Chart Excel Template: A Setup GuideExcel does not have a separate chart type called a stacked waterfall chart. To make one in Microsoft Excel for Microsoft 365…
- Sparklines in Microsoft Excel 365: Create and Format ThemYes. Microsoft Excel for Microsoft 365 includes sparklines: tiny charts placed inside worksheet cells to show trends in nearby data. To create…
- Set Up a Waterfall Chart in Excel: A Practical GuideTo set up a waterfall chart in Microsoft Excel for Microsoft 365 on Windows, place each category in one column and its…
- Waterfall Chart in Excel: Setup and TroubleshootingTo set up a waterfall chart in Excel for Microsoft 365 on Windows, put each step and its positive or negative change…
- Waterfall Chart in Excel: Sample Data and StepsTo make a waterfall chart in Excel for Microsoft 365 on Windows, enter categories in one column and the starting total, increases,…
- Reverse Waterfall Chart in Excel: How to Make OneTo make a reverse waterfall chart in Excel for Microsoft 365 on Windows, enter the starting total and the changes in the…
- How to Remove a Trendline from an Excel ChartTo remove a trendline from an Excel chart in Microsoft 365 for Windows, click the trendline to select it, then press Delete.…
- Revenue Waterfall Chart in Excel: Build and Format OneTo make a revenue waterfall chart in Excel for Microsoft 365, put the opening revenue and each increase or decrease in a…
- Power Pivot From Multiple Excel Files: How It WorksYes. In Excel for Microsoft 365 on Windows, use Power Query to import or combine data from multiple Excel files, then load…
- Pivot Table Combo Chart: How to Build and Format OneIn Excel for Microsoft 365 on Windows, you cannot directly turn a PivotChart into a combo chart. The practical workaround is to…
- Pivot Chart Hide Filters? Hide Field Buttons in ExcelYes. In Excel for Microsoft 365 on Windows, select the PivotChart, then choose PivotChart Analyze > Field Buttons > Hide All. This…
- Pivot Table in Excel: Shortcut Keys to Create and RefreshIn Excel for Microsoft 365 on Windows, select a cell in your source data and press Alt+N, V, T to open the…
- Pivot Chart Hide Buttons: How to Remove Field ButtonsTo hide PivotChart buttons in Excel for Microsoft 365 on Windows, select the chart, then choose PivotChart Analyze > Show/Hide > Field…
- Pivot Chart Hide Fields? What You Can Hide in ExcelTo hide the field buttons on an Excel PivotChart, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons >…
- Pivot Chart Gantt Chart in Excel: What WorksYes, you can make a Gantt-style PivotChart in Excel by plotting task start dates and durations as a stacked bar chart, then…
- Pivot Chart Grand Total: What Excel Shows and How to Add ItA PivotChart does not plot a PivotTable’s grand total as a chart category or data point. Excel keeps grand totals in the…
- Pivot Chart Help: Build and Troubleshoot OneIn Excel for Microsoft 365 on Windows, select a cell in your data, choose Insert > PivotChart, confirm the data range and…
- Pivot Chart Colors by Value in Excel: Setup GuideExcel PivotCharts do not automatically change each data point’s color according to its value, and worksheet conditional formatting does not control PivotChart…
- Pivot Charts and Zero Values: Why Excel Hides ThemYes, an Excel PivotChart can appear not to show zero values: a zero has no visible height in a column or bar…
- Pivot Chart Formatting Options in Excel 365 ExplainedIn Excel for Microsoft 365 on Windows, format a PivotChart with the contextual Chart Design and Format tabs: adjust its chart type,…
- Pivot Chart Axis Formatting in Excel: What to ChangeTo format a PivotChart axis in Excel for Microsoft 365 on Windows, select the chart, right-click the axis, and choose Format Axis;…
- Pivot Chart Axis Options in Excel: What You Can ChangeIn Excel for Microsoft 365 on Windows, PivotChart axis options let you control what appears on the category and value axes, how…
- Pivot Chart Slicers: How to Add and Use ThemYes. In Excel for Microsoft 365 on Windows, select the PivotChart, choose PivotChart Analyze > Insert Slicer, select one or more fields,…
- Pivot Bar Chart in Excel: How to Build and UseA pivot bar chart is a horizontal bar chart connected to a PivotTable, so you can summarize and explore records by category…
- Pivot Chart Filters in Excel: How to Add and Use ThemYes. In Excel for Microsoft 365 on Windows, select the PivotChart and use its field-button drop-downs to filter, or choose PivotChart Analyze…
- Pivot Chart Add Legend: How to Show and Format It in ExcelTo add a legend to a PivotChart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design >…
- Pie Chart Creator Online in Excel: How to Make OneYes. In Excel for the web, select a table containing category names and values, then use the Insert tab to add a…