Chart & Visualization Issues

How to Increase Spacing Between an Excel Legend Symbol and Label

Maira Mehtab Sep 28, 2026 868 views

Question details

The user wants to add more space between the series symbol (marker) and the series name text in an Excel scatter chart legend because the default spacing is too tight.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adjusting chart legend formatting to improve the readability and aesthetics of a scatter chart.
Observed behavior: Excel does not offer a built-in formatting control to independently adjust the spacing between the legend marker and the text label.

Before you start

Before modifying your chart data, ensure your chart is linked to a specific data range in your worksheet, as this workaround requires editing the source data cells or creating a helper column.

Solution 1Recommended

Use a Helper Column for Chart Series Names

Since Excel lacks a direct setting for legend spacing, the safest and most effective workaround is creating a separate range that adds blank spaces before the series name without modifying your original data.

By inserting space characters at the beginning of your series names in a helper column, you can artificially push the text away from the legend symbol, creating the illusion of increased spacing while keeping your original data intact for formulas.

Create a Helper Column

Insert a new column next to your original series names in the worksheet.

Add Spaces using a Formula

In the new column, type a formula like `=" " & A2` (assuming A2 contains your original series name) to automatically add two leading spaces. Press Enter and drag the formula down for all series names.

Open Chart Data Selection

Right-click your scatter chart and choose 'Select Data' from the context menu.

Edit Legend Entries

In the Select Data Source dialog, click on a series under 'Legend Entries (Series)' and click the 'Edit' button.

Link to the New Names

Clear the 'Series name' field, select the corresponding cell in your new helper column, and click 'OK'. Repeat this for all series, then click 'OK' again to apply the changes to your chart legend.

Preserving Data Integrity: Using a helper column ensures that any VLOOKUP or exact-match formulas relying on your original series names will not break.

Solution 2

Directly Add Leading Spaces to Source Data

If you do not use formulas that rely on exact text matches for your series names, you can quickly add spaces directly to the source cells.

Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet and Charting Needs

While adjusting advanced chart formatting like legend spacing requires manual workarounds in traditional spreadsheet software, WPS Office provides a highly compatible, free, and lightweight alternative for all your data visualization tasks. Enjoy a familiar interface and seamless migration without heavy subscription fees.

1. Download and Install WPS Office: Get the free suite from the official WPS website and install it on your computer or mobile device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file seamlessly without worrying about data or formatting loss.
3. Edit Charts Seamlessly: Use the highly compatible charting tools to continue working on your scatter charts, adjusting data ranges and labels easily.

Highly compatible with Microsoft Excel (.xlsx) files and chart formatsLightweight and fast spreadsheet processing for large datasetsRich built-in chart templates for advanced data visualizationFree to use with a familiar user interface that requires no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Is there a direct formatting option to change legend spacing in Excel?

No, Excel does not provide a built-in formatting control to natively adjust the gap between the legend symbol (marker) and the series name text. You must use workarounds like adding leading spaces to the series names.

Will adding spaces to series names affect my formulas?

Yes, adding spaces directly to your source data can break exact-match lookup formulas, such as VLOOKUP, XLOOKUP, or INDEX/MATCH. It is highly recommended to use a separate helper column specifically for your chart labels to keep the original data intact.

Can I adjust the legend size instead of the text spacing?

You can increase the font size of the legend text or drag the legend bounding box to resize the overall container, but this scales the entire legend uniformly and will not independently widen the specific gap between the symbol and the text.

Excel & Data Problems