Chart & Visualization Issues

Remove Blank Space to the Right of a PowerPoint Chart

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the data selection window

Select the chart, then choose Chart Design > Select Data.

2
Review the source range

Check the Chart data range for extra blank rows or columns. Use Edit Data if you need to inspect the underlying worksheet.

3
Correct the range

Adjust the Chart data range to include only the intended data and labels, or remove an unwanted series from the series list.

4
Check the chart

Click OK and close the data worksheet if it is open. Check whether the blank space to the right has disappeared.

If the space remains: The chart layout may also reserve room for elements such as a legend. Select the chart and inspect its layout before making further changes.
Edit charts in WPS Presentation

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. 1. Open the presentation: In WPS Presentation, choose Open and select your PowerPoint file.
  2. 2. Open chart data: Select the chart and choose Edit Data from the chart tools or the chart's right-click menu.
  3. 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. 4. Review and save: Close the data sheet, check the chart, and choose File > Save or Save As.
Remove unused cells from a chart's data rangeOpen and edit Microsoft PowerPoint PPT and PPTX filesWork with a familiar presentation interfaceUse WPS Office for free
microsoft office alternative - wps office

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.