Excel Chart Sheet Too Small? Check the Default Printer

A tiny Excel chart that won't resize on its own chart sheet can come from the default printer setup. Choose an available Windows default printer and restart Excel. Several owners fixed it without rebuilding their charts.

This fits a chart that becomes small on its own tab but looks normal inside a worksheet. Missing data or small labels alone need different checks. Try the printer before changing the chart's data or design.

1. Give Windows an available default printer

Save the workbook, then exit Excel. Check which printer Windows uses by default. The original owner reports included a missing default printer and a network printer that wasn't available away from its network.

On Windows 11, open Settings > Bluetooth & devices > Printers & scanners. Turn off Let Windows manage my default printer, select an available printer, then choose Set as default.

On Windows 10, open Settings > Devices > Printers & scanners. Clear Let Windows manage my default printer, select the printer, choose Manage, then Set as default. Its status should change to Default.

Diagram showing the printer comparison for a tiny Excel chart sheet

For the original Windows 7 setup, open Start > Devices and Printers. Right-click the available printer and choose Set as default printer. Use an installed printer you recognize rather than adding an unknown driver for this check.

The current default-printer instructions also explain why the default button can be missing when Windows manages the choice automatically. Turn that setting off before selecting a fixed default.

Reopen Excel and the affected workbook, then select its chart-sheet tab. If the graph now fills the page normally, changing the default printer helped. Check another affected workbook before editing individual chart settings.

If it remains tiny, keep the new default for the next comparison. Simply zooming the chart wasn't enough in the original report, so don't keep adjusting zoom in place of checking the printer choice.

2. Compare an installed local printer with the network one

If the current default is a workplace network printer, try an available installed local printer instead. When Microsoft XPS Document Writer is already listed, it can serve as a comparison without needing a physical printer online.

One owner fixed the chart size through the Microsoft forum's printer workaround by choosing XPS Document Writer as default. Another reported trouble with a network default when the computer wasn't connected to that network.

Close and reopen Excel after making the change, then inspect the same chart sheet. Leave your workbook and chart unchanged during this check. That makes the effect of switching printers easier to see.

I'd try an existing local printer before repairing Office. It takes less time, and owners confirmed that changing the printer fixed their charts. An Office repair had already failed for the asker whose charts became tiny.

If the local choice works, ask IT or the printer maker to check the normal printer's driver and availability. Explain that Excel chart sheets shrink with that printer selected and recover with the local choice.

Don't install XPS Document Writer just to match a printer named in an old reply. If it isn't present, use another suitable printer already installed or ask IT for a supported comparison on that PC.

3. Check the chart sheet's paper size and margins

With the affected chart sheet selected, inspect Page Layout > Margins and try Normal. Check Page Layout > Size and choose the paper you intend to use, such as Letter or A4.

Open File > Print and inspect the preview without printing. Look for a chart that occupies the intended page area rather than a small graph surrounded by excessive margins. Confirm that the selected printer is the one you just tested.

Check the margins after trying the default printer. Excessive margins leave less room on the printed page; check that your paper settings leave enough room for the chart's title and labels.

If only one chart sheet looks wrong while others display normally with the same printer, compare their paper size and margins. I'd check those settings before deleting the chart or changing every workbook.

For an existing chart whose data is wrong, revisit how Excel charts use selected data. Page settings won't correct an incorrect range or an empty series.

When the series exists but Excel graph lines disappear, try the chart-type repair on a copy before rebuilding the annotations.

If the chart still shrinks with an available default and ordinary page settings, try moving a copy into a worksheet. Keep a saved copy before changing where the chart lives.

4. Move a copy into a worksheet when you need it now

In desktop Excel, select the chart and open Chart Design > Move Chart. In older Excel, the tab is named Design under Chart Tools. Choose Object in, select a worksheet, then choose OK.

The chart becomes an object on that worksheet instead of filling a separate chart sheet. Select its outer edge and drag a corner sizing handle to adjust its size. Check its title, legend and labels after resizing.

The original asker reported that moving the chart into a worksheet made the whole chart visible again. Moving it back to a new chart sheet made it small again, which is why this is a temporary layout workaround.

Work in a copy if colleagues or printed reports still need the original chart-tab arrangement. Moving it changes where people find it, even though the plotted data can remain the same.

For a horizontal bar chart, check bar order and readable labels after resizing. After making the chart larger, check that readers can still understand its values.

Give support the printer comparison and a sample

If all chart sheets are affected, record the Excel version and the default printer's exact name. Include whether an available local printer changes the result and whether the same workbook looks normal on another computer.

When only one file fails, make a sample with invented data and the same chart-sheet behavior. Share that with your service desk or Microsoft Support instead of sending private business records.

Ask them to check chart-sheet sizing against the printer driver, not simply to recreate the chart. The original report involved several previously working files, and the confirmed successes came from printer changes.

The Short Version

Set an available default printer and restart Excel. Compare a local printer if needed, then check page settings. Place a copy of the chart in a worksheet while support checks a persistent printer-related fault.

Checked November 16, 2026.

If you have any business, I can build it online

Hi, I’m Hamza. I’ve been building websites and online shops for business owners since 2019, and I also built this site you’re reading.

Tell me what business you have or what you’re working on. I’ll look into how much it can grow online, and then we talk. You don’t have to buy anything or hire me first.

Chat with me on my site and I’ll show you proof of businesses I’ve helped and how they’ve grown.

Written by Isaac Smith

Isaac Smith is the founder and editor of PC Glance, a website that covers computers, laptops, and technology. He is a tech enthusiast and a computer geek who loves to share his insights and help his readers make smart choices when buying tech gadgets or laptops. He is always curious and updated about the latest tech trends.

More from Isaac Smith

Leave a Comment