Forum Discussion
PivotChart is tall and narrow with lots of white space
Everything I know about PivotCharts is self-taught, so there are some gaps in my knowledge.
Normally when I make a PivotChart, the plot area sizes itself so that it fits nicely within the chart area. However, the column chart I'm currently viewing is very narrow for some reason. Why did it generate this way, and is there any way to change the height to width ratio?
Seems a known behavior in Excel when the chart area and plot area scaling do not automatically adjust to the available space. It usually happens when the chart was created from a PivotTable with many category labels (like months across several years) or when Excel’s default chart dimensions were constrained by the surrounding cells or container.
Try resizing manually:
- Click the chart border (not the plot area).
- Drag the corner handles to widen the chart horizontally.
- If the plot area doesn’t expand proportionally, right‑click the chart > Format Chart Area > Size & Properties > Lock aspect ratio (uncheck).
- Adjust until the bars fill the chart area evenly.
2 Replies
Seems a known behavior in Excel when the chart area and plot area scaling do not automatically adjust to the available space. It usually happens when the chart was created from a PivotTable with many category labels (like months across several years) or when Excel’s default chart dimensions were constrained by the surrounding cells or container.
Try resizing manually:
- Click the chart border (not the plot area).
- Drag the corner handles to widen the chart horizontally.
- If the plot area doesn’t expand proportionally, right‑click the chart > Format Chart Area > Size & Properties > Lock aspect ratio (uncheck).
- Adjust until the bars fill the chart area evenly.
Yes—you can resize both the whole chart and the plot area inside it. They’re separate, which can explain why making the chart larger doesn’t always remove the white space.
First, select the chart’s outer border and drag a side handle to make it wider. You can also enter exact dimensions under Chart Format > Size.
If the outer chart is already wide enough, select Plot Area from the Current Selection dropdown on the Format tab. Drag its side handles outward to fill more of the chart. Legends, axis labels and PivotChart field buttons can also take up space; hide or reposition any you don’t need.
If it’s only the individual columns that look too thin, right-click a column, choose Format Data Series, and reduce Gap Width. That changes column thickness, not the chart’s overall proportions.
