Chart & Visualization Issues

How to Add New Data to an Existing Excel Chart

Adam Davis Sep 27, 2026 869 views

Question details

The user needs to add a new data series or modify an existing one in an already created Excel chart.

How to Add New Data to an Existing Excel Chart

Product: Excel
Device & OS: not provided
Scenario: Updating an existing chart with new data without recreating the entire visualization.
Observed behavior: The user wants to expand or modify the chart's data range to reflect new figures.

Before you start

Ensure the new data you want to add is already typed into your spreadsheet adjacent to or near your original dataset.

Solution 1Recommended

Use the Select Data Feature to Add a New Series

This is the most reliable method to add new data series or edit existing ones directly through the Chart Design tab.

The Select Data Source dialog box allows you to precisely control which cells feed into your chart, making it easy to add entirely new data columns or tweak the names of existing series.

Select the Chart

Click anywhere on your existing chart to reveal the Chart Tools in the top ribbon.

Open Chart Design Tab

Navigate to the 'Chart Design' tab that appears on the main menu bar.

Click Select Data

Click on the 'Select Data' button to open the Select Data Source dialog box.

Add New Data

Under the Legend Entries (Series) section on the left, click 'Add'. Then, select the name and cell range for your new data series directly from your spreadsheet.

Confirm Changes

Click 'OK' to close the dialog boxes and apply the newly selected data series to your chart.

Use the Select Data Feature to Add a New Series

Quick Update: Your chart will instantly update to visually reflect the newly added data points.

Solution 2

Copy and Paste New Data Directly onto the Chart

A quick shortcut to add new data to a chart without navigating through dialog menus.

Update Charts Easily with WPS Spreadsheet

Easily Add New Data to Charts in WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools that make it simple to visualize your data. You can quickly add, edit, or remove data series from any chart using a familiar, easy-to-navigate interface.

1. Open your Spreadsheet: Launch WPS Office and open your workbook containing the chart.
2. Select the Chart: Click on the chart you want to update to activate the Chart Tools menu.
3. Choose Select Data: Click the 'Select Data' icon in the top ribbon, then use the intuitive dialog box to 'Add' or edit your data series.

Fully compatible with Microsoft Excel (.xlsx) formats and advanced chart layouts.Intuitive Select Data dialog for seamless chart updates and data range modifications.Free, lightweight, and fast spreadsheet processing for everyday office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Can I resize the data range by dragging instead of using the Select Data menu?

Yes. When you click on the chart, the referenced data in your worksheet will be highlighted with colored borders. You can simply drag the corner handles of these colored borders to include your new adjacent data.

Why is my newly added data series not showing up in the chart?

Ensure the new data format matches the existing series. Also, check if the specific chart type supports multiple data series, and verify that the correct X and Y axis values were properly selected in the Select Data Source dialog.

How do I add a secondary axis for my new data series?

After adding the new data to the chart, right-click on the new series line or bar in the chart, select 'Format Data Series', and check the box for 'Secondary Axis' under the Series Options menu.

Excel & Data Problems