How to Add Data to an Existing Chart in Excel (5 Easy Ways)

Method 1 – Add Data to an Existing Chart on Same Worksheet by Dragging

Let’s say we have got a dataset of sales for sales assistants who work at a shop over a certain period of time.

Dataset for Adding Data to an Existing Chart

We have made a chart describing the sales of these representatives over the time period mentioned.

Chart for adding Data to an Existing Chart

To add data to the existing chart by using this method, just follow the steps below:

  • First, add a new data series to your previous data set (i.e. sales of Stephen).

Adding Data to an Existing Chart

  • Then, click the chart area and you’ll see the data source which is currently displayed is selected on the worksheet presenting the sizing handles, but the new data series is not selected.

Adding Data to an Existing Chart in Excel

  • Now, drag the sizing handle to introduce the new data series and the chart will update.

Read More: How to Expand Chart Data Range in Excel


Method 2 – Add Data to an Existing Chart on a Separate Worksheet

Let’s say, for the dataset below, we want to update the chart on a separate worksheet by adding a new data series.

  • First, right-click on the chart and click Select Data.

Updating Data to an Existing Chart

  • Now, a dialogue box will show up. Click Add on the Legend Entries (Series) box.

Add Data to an Existing Chart in Excel

  • Then, go to the sheet containing the new data entries. Assign a new Series name (i.e. Stephen).

Updating an Existing Chart in Excel

  • Again, assign the cells containing new data entries as the Series values.

Updating an Existing Chart in Excel

  • The heading of the new data entries will show up on the Legend Entries box. Click OK on the dialogue box.

Updating an Existing Chart in Excel

  • Finally, your existing chart will show the updated data.

Updating an Existing Chart by Adding Data

Read More: Selecting Data in Different Columns for an Excel Chart


Method 3 – Update Data to a Chart by Pasting New Entries

For our previous dataset, we will now show how to update an existing chart by just pasting the new data entries on the chart.

  • First, copy the new data entries of the dataset.

Adding Data to Existing Chart

  • Now, just click outside on the chart and hit paste. Your chart will be updated.

Read More: How to Select Data for a Chart in Excel


Method 4 – Use Paste Special Option to Add Data to a Chart

For the same datasetwe will now learn to add data to the existing chart by using the paste special option.

  • First copy the new data entries and click on the chart.
  • Go to the Home tab > Paste > click Paste Special

Adding Data to Existing Chart in Excel

  • After that, a dialogue box will show up displaying multiple options for you for full control of what is pasted.

  • Now, choose the option according to what you want and your updated chart will be ready.

Method 5 – Use Pivot Table to Add Data to an Existing Chart

For our same dataset, we’ll now show how to update the chart by using a pivot table.

  • Select the data range> go to the Home tab> click Format as Table.
  • Choose a design for the table.

  • Create Table dialogue box will show up. Mark if your table has headers. Click OK.

  • Now, your table will be created.

  • After that, go to the Insert tab> click Pivot Table> select From Table/Range.

  • Now, choose whether you want your pivot table on the same sheet or a different sheet.

  • Pivot Table Field will show up.

  • Drag your data range to the drag fields you want (i.e. drag Month to Rows)

  • Drag the other data ranges to the other drag field ( i.e. Mike & Adam to Values)

  • Go to the Pivot Table Analyze tab> Pivot Chart.

  • Create a chart (i.e. Clustered Column)

  • Your sheet will show the chart.

  • Here, drag your new data entries to the field (i.e. Stephen to Values).

  • Finally, your chart will show the added new data entries.

Download Practice Workbook


Related Articles


<< Go Back to Edit Chart Data | Excel Chart DataExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Hasan
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo