Quickly edit chart series data

Making edits to chart series data or references? Here’s how to edit chart series information quickly.

EQ

This tip helps edit chart series data quickly.

The Quick Tip shows how to quickly edit the source range of a chart series.

The Bonus Tip helps you quickly modify existing axis labels in a chart series.

With the Expert Tip you can quickly name or rename a chart series.

We hope you find these tips useful.

Excel Quicker!

Quick Tip

How to quickly edit the data source of a chart series

Sometimes you have an existing chart that contains one or more data series, and you just want to quickly edit the data source.

Maybe you need to extend the existing data when an extra point is added.

Other times, you may want to move the whole data series to draw from a different row, column or worksheet.

To edit the data source for an existing series on a chart, you can choose “Select Data” from the Chart Design tab on the ribbon toolbar.

Select Data toolbar button
Select Data toolbar button

This shows the Select Data Source dialog, which lets you edit the source data for your chart.

Select Data Source dialog
Select Data Source dialog

You can edit the “Chart data range” to change where your chart data comes from… but did you know that there is a quicker way?

Quickly edit chart series data source

Here’s how to do it quickly:

Time Needed : 1 minutes

How to quickly edit the data source of a chart series in Excel

  1. Select the series on that chart you wish to edit

  2. Edit the data range directly in the Formula Bar

    This is the second-to-last parameter shown for the series.Example step 2: quickly edit chart series data source

  3. Change the range reference to the new data source

    This will update the selected chart series to the new data source.

A great time-saving use for this method is when you need to create a new series on an existing chart. You can just copy and paste the existing series, then edit the data range of the new series.

 

Bonus Tip

Please log in to see the bonus tip.

No login?
Get one for free.

Don’t have a login?

Get a login for free on our standard plan, and get a new tip each week.

Get started >>

All logins also get access to the bonus tip each week.

Get even more

Get even more with one of our reasonably priced paid plans, with access to features like:

  • Quicksheet PDF summaries
  • Example files
  • VBA syntax
  • Additional expert tips each week
  • Advance publication

Get quicker >>

View our plans to see what else you are missing, or join for free on our Standard plan.

 

Expert Tip

Please log in to see the expert tip.

Don’t have a login? Get one.

Download files for this tip

Get Quicksheet

Quicksheet

Download example

Example file

No login?
Get one for free.