Skip to content
Related Articles

Related Articles

Modifying Data Range in Excel Charts

View Discussion
Improve Article
Save Article
  • Last Updated : 24 Jul, 2022
View Discussion
Improve Article
Save Article

After the outline is made, one ordinarily does not have to stress over refreshing the graph physically. That is on the grounds that Excel will consequently refresh the graph when the source information changes, as long as the estimation is set to Automatic. Let’s learn how to modify the excel chart data range.

Add a Data Series

Assuming you want to add extra information from the bookkeeping sheet to the graph after it’s made, you can change the source information region.

  • Select the chart. In the worksheet, click an estimating handle for the source information and drag it to incorporate the extra information.
Selecting-chart-for-dataset

Note: The new information should be in cells neighboring the current graph information.

Rename a Data Series

Outlines are not totally attached to the source information. You can change the name and upsides of an information series without changing the information in the worksheet.

  • Select the graph.
Selecting-graph
  • Click the Design tab.
Clicking-chart-design
  • Click the Select Data button.
Clicking-select-data
  • Select the series you need to change under Legend Entries (Series).
Selecting-series-where-change-required
  • Click the Edit button.
Clicking-edit-button
  • Type the mark you need to use for the series in the Series name field.
Typing-name-in-series-name
  • Click OK two times.
Clicking-okay-twice
  • The name is refreshed in the outline, yet the worksheet information stays unaltered.
Name-refreshed

The graph refreshes the name, yet the worksheet information stays unaltered.

Reorder a Data Series

You can likewise change the request for information in the outline without changing the request for the source information.

  • Select the chart. Then Click the Design tab.
Clicking-chart-design
  • Click the Select Data button.
Clicking-select-data
  • From the Select Data Source exchange box, select the information series you need to move. Then click the Move Up or Move down button. At long last snap, OK.
Selecting-information-series-required-to-move
  • The diagram is refreshed to show the new request for information. However, the worksheet information stays unaltered.
Chart-refreshed
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!