How to Remove Blank Values from an Excel Pivot Chart Axis in WPS Office Spreadsheets
Question details
The user needs to remove unwanted blank categories from the horizontal axis of an Excel PivotChart in WPS Office Spreadsheets.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A PivotChart linked to a PivotTable displays extra blank labels on its horizontal axis, and the user wants a clean chart.
- Observed behavior
- The horizontal axis shows unwanted blank categories caused by truly empty cells or zero values in the source field.
Open the workbook in WPS Office Spreadsheets and identify whether the axis field contains blank cells, zero values, or formulas that return empty strings. Confirm that the PivotChart is linked to the PivotTable you plan to filter.
Filter Blank Items from the Axis Field in the PivotTable
Use this when the source field contains truly empty cells and the PivotChart axis shows a (blank) category. It removes the blank category from both the PivotTable and linked chart.
WPS Office Spreadsheets treats blank cells as a separate item in PivotTables. Excluding that item from the axis field keeps the rest of the categories unchanged.
Click any cell inside the PivotTable that is linked to your PivotChart in WPS Office Spreadsheets.
In the PivotTable Fields pane, click the filter arrow next to the field used for the horizontal axis, or click the row/column label filter in the PivotTable.
In the filter list, uncheck the box for '(blank)' and click OK.
Right-click the PivotTable and choose Refresh, then check that the blank category no longer appears on the chart axis.
Remove Zero-Value Categories from the PivotChart Axis
Use this when the axis categories are zeros rather than empty cells, because WPS Office Spreadsheets treats zero values as data and does not automatically hide them.
Clean Up Blank PivotChart Axis Categories in WPS Office Spreadsheets
WPS Office Spreadsheets lets you remove blank or zero source entries from a PivotTable so the linked PivotChart axis shows only meaningful categories. You can do this free without losing Excel compatibility.
- 1. Open the workbook: Download WPS Office, open the Excel workbook in WPS Office Spreadsheets, and click the PivotChart's linked PivotTable.
- 2. Open field settings: Use the PivotTable Fields pane to find the axis field and click its filter arrow.
- 3. Exclude blank or zero items: Uncheck '(blank)' or zero values, depending on the source data, and click OK.
- 4. Refresh and verify: Right-click the PivotTable and choose Refresh, then confirm the PivotChart axis no longer shows unwanted categories.
Frequently Asked Questions
Why does a blank category still appear on my PivotChart axis after I delete visible empty cells?
The source range may still include blank cells, formulas returning empty strings, or spaces. In WPS Office Spreadsheets, expand the PivotTable data source, filter the axis field, uncheck '(blank)', and refresh the PivotChart.
How do I remove zero values instead of blank cells from a PivotChart axis?
Filter the source data by selecting the range, clicking Data > Filter, and unchecking 0 for the axis field. If zero values are placeholders, replace them with empty cells using Ctrl+H before refreshing the PivotTable.
Does filtering blanks in the PivotTable also update the PivotChart?
Yes. A PivotChart is linked to its PivotTable in WPS Office Spreadsheets. After you filter or refresh the PivotTable, the chart axis updates automatically.
Can I hide blank axis labels in the PivotChart only without changing the PivotTable?
No direct chart-only filter is available. Since the PivotChart categories come from the PivotTable, filter or clean the axis field in the PivotTable or source data to remove the blank labels from both.
