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

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.

 

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.

 

Step 2: Create the chart. Go to Insert> Charts and select 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).

 

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.

 

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).

 

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

 

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

 

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.

 

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.

 

 

Step 3: The resulting chart is shown below.

 

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