Remove Blank Space to the Right of a PowerPoint Chart
Question details
The user wants to remove unexpected blank space to the right of a PowerPoint chart.
- Product
- Microsoft PowerPoint
- Device & OS
- not provided
- Scenario
- A chart appears to reserve more horizontal space than its displayed data requires.
- Observed behavior
- Blank space appears beside the chart, potentially because its data range includes an extra blank row or column.
Select the chart and identify the last row and column that contain data or labels you want to display. Keep any headers and categories needed by the chart when adjusting its range.
Exclude Blank Rows or Columns from the Chart Data Range
Use this method when the chart's source range includes unused cells beyond the intended data.
Select the chart, then choose Chart Design > Select Data.
Check the Chart data range for extra blank rows or columns. Use Edit Data if you need to inspect the underlying worksheet.
Adjust the Chart data range to include only the intended data and labels, or remove an unwanted series from the series list.
Click OK and close the data worksheet if it is open. Check whether the blank space to the right has disappeared.
Adjust Chart Data in WPS Presentation
Open your presentation in WPS Presentation and check the chart's source data for extra blank rows or columns. Adjust the range to include only the intended data and labels.
- 1. Open the presentation: In WPS Presentation, choose Open and select your PowerPoint file.
- 2. Open chart data: Select the chart and choose Edit Data from the chart tools or the chart's right-click menu.
- 3. Adjust the source range: In the data sheet, adjust the selected chart range to exclude unused blank rows or columns while keeping the necessary labels.
- 4. Review and save: Close the data sheet, check the chart, and choose File > Save or Save As.

Frequently Asked Questions
Why is there blank space to the right of my PowerPoint chart?
The chart's source range may include an extra blank category or series. Select the chart and open Chart Design > Select Data to inspect the range.
How do I see the cells used by a PowerPoint chart?
Select the chart and choose Chart Design > Edit Data to open its data worksheet. Compare the selected cells with the data and labels you intend to show.
Should I remove every blank cell from the chart data?
No. Some blank cells may be intentional. Exclude only unused rows or columns outside the intended chart range, and retain the headers and categories the chart needs.
What if changing the data range does not remove the space?
Inspect the chart layout for elements such as a legend that may be using space. Select the chart and use its chart layout controls to review those elements.




