Open In App

How to Update, Change and Manage the Data in a Chart in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Charts in Microsoft Excel enable you to display data in a way that has the most possible impact on your audience. Apart from displaying, it helps the audience to understand the data well and helps them to read the data correctly. Charts can be of many types like Pie charts, Bar charts, Scatter charts, Hierarchy charts, and so on. Every chart serves a specific purpose and helps to understand the relevant data.

Steps to Update, Change and Manage Data Used in a Chart in Excel

The example is performed on MS Excel 2016. All the functionalities will be there in the later or backward versions of Excel but the function place can change.

For Example, We are using the example to perform the desired operations.

Dataset-with-respective-chart

 

Update Chart Values

Step 1: When the chart was created, select the extra rows to update the chart values as desired. In the image below, the data is till cell C11, but I’ve selected till C14 to help to add more values to the chart. The chart of the selected data will look the same as taken in the example.

Selecting-data

 

Step 2: Create the chart. Go to Insert> Charts and select Bar Chart.

Creating-bar-chart

 

Step 3: Now, in cell B12, add any programming language of your choice and add the number of enrolled students. The chart will automatically update and you’ll see the added language and number of enrolled students (as shown below).

Chart-updating-automatically

 

Change Chart Values

From the dataset, change the data from any cell(which has some data in it). You can change the number of Enrolled Students or change any programming language. You can also change the case of the programming language into the desired format. Here, I’m changing the enrolled student’s value of the CIP course, and the results are shown below.

Changing-value-of-cip

 

Manage Chart Data

You can manage the chart data by removing any column from the chart, adding a trendline to the chart, displaying the axis title, data label, and so on. Here, we’ll add the Trendline to the chart, and remove and add an entry.

Step 1: Click on the chart area and a menu bar will appear in the corner of the chart (as highlighted).

Clicking-chart-area

 

Step 2: Click on the “+” sign and another menu will open that bears the name “Chart Elements“.

Chart-elements-opens

 

Step 3: Click on the Trendline checkbox and you’ll see a trendline on the chart.

Clicking-on-trendline

 

Similarly, if you want to add an Error Bar, Data Table, and Legends to your chart. Steps to remove and add entries from the chart.

Step 1: Right-click on the chart area and a drop-down will appear (as shown below). Right, Click on Select Data.

Selecting-data

 

Step 2: A dialogue box will appear as shown. Uncheck the check box along with the language name and the bar corresponding to that language will disappear from the chart. Here, the checkbox along with C++ is unchecked. and then click OK.

Dialogue-box

 

Unchecking-C++

 

Step 3: The resulting chart is shown below.

Chart-result

 

Similarly, you can perform the operation of adding a chart bar.


Last Updated : 05 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads