Chart & Visualization Issues

How to Keep Excel Chart Text Boxes Visible When Printing

Steven Parker Oct 13, 2026 868 views

Question details

The user needs to prevent custom text annotations on Excel charts from disappearing during printing or image saving, and ensure they remain correctly positioned when the chart is resized.

How to Keep Excel Chart Text Boxes Visible When Printing

Product: Excel
Device & OS: not provided
Scenario: Adding custom text annotations to an Excel chart, then attempting to resize the chart, print it, or save it as an image.
Observed behavior: Standard text boxes disappear when the chart is printed or saved as an image, and they fail to maintain their relative anchored position when the chart dimensions change.

Before you start

Verify that your chart layout and primary data points are finalized, as significantly changing the chart type later may reset custom label positions.

Solution 1Recommended

Replace Text Boxes with Editable Data Labels

The most reliable way to anchor text to a chart for printing and resizing is to use native data labels and edit their text contents.

Excel does not provide a built-in way to dynamically anchor a floating text box to a specific relative position inside a chart. However, data labels are natively linked to the chart's data points.

By replacing standard text boxes with edited data labels, you guarantee that your annotations will remain visible during printing and will automatically scale and move when you resize the chart.

Enable Data Labels

Click on your chart to select it, click the 'Chart Elements' button (the plus icon) that appears next to the chart, and check the 'Data Labels' box.

Edit the Label Text

Click directly on the specific data label you want to modify to highlight it, click it a second time to place your cursor inside, and type your custom annotation.

Adjust Label Formatting

Right-click the edited data label and select 'Format Data Label' to adjust the background fill, border, and font to make it look like a text box.

Remove Old Text Boxes

Select and delete the original floating text boxes that were causing the printing and resizing issues.

Replace Text Boxes with Editable Data Labels

Positioning Advantage: Because the edited data label is anchored to a data point, it will seamlessly maintain its relative position even if you drastically change the chart's width or height.

Solution 2

Adjust Print Object Settings for Existing Text Boxes

If you absolutely must use floating text boxes, you can check their property settings to ensure they are configured to print.

Create and Print Custom Charts with WPS Spreadsheet

WPS Spreadsheet offers an intuitive chart editing experience, allowing you to easily add data labels, customize text, and print charts without losing your formatting or annotations.

1. Open your workbook: Launch WPS Spreadsheet and open the file containing your chart.
2. Add data labels: Click your chart, select the 'Chart Elements' shortcut on the right, and enable 'Data Labels'.
3. Customize your text: Double-click any generated data label to overwrite it with your custom annotation.
4. Print securely: Go to Menu > Print to preview your layout and securely print the chart with all labels intact and correctly positioned.

100% compatible with Microsoft Excel chart formats (.xlsx)Easy-to-use chart elements menu for quick label editingReliable print preview ensures your charts print exactly as they appear on screenFree, lightweight, and fast office suite

microsoft office alternative - wps office

Frequently Asked Questions

Can I group a floating text box directly with a chart?

Yes, you can hold down the Ctrl key, click both the chart edge and the text box, right-click, and select 'Group'. This helps keep them together when moving the chart, but using editable data labels is still vastly superior for dynamic resizing and avoiding print errors.

Why is the 'Print object' option greyed out in my text box settings?

The object properties might be locked because the worksheet is protected. Navigate to the 'Review' tab on the ribbon and click 'Unprotect Sheet' to allow modifications to the object's print properties.

How do I restore the original data label values if I overwrite them?

If you manually typed over a data label and want the original numeric value back, select the label, right-click, and choose 'Reset Label Text'. Alternatively, you can uncheck and re-check 'Data Labels' in the Chart Elements menu to reset all of them at once.

Does saving the chart as a picture resolve the text box issue?

Sometimes text boxes disappear even when right-clicking and choosing 'Save as Picture'. Grouping the text box with the chart before saving can help, but replacing the text box with a modified chart title or data label guarantees it will be included in the saved image.

Excel & Data Problems