Dynamic Chart Range using the Excel Table

This feature is available from Excel 2007 version and higher which we generally use nowadays. It is the most efficient method because when we add new data to the original source table it gets automatically updated.

The steps to create a dynamic chart range using a table are as follows :

Step 1: Select the table.

Step 2: Click on the Insert tab from the top of the Excel window.

Step 3: Click on the Table.

Step 4: The Create Table window opens. Since the above table has headers “Courses”, “Number of Students” check the box as shown below and then click on OK.

The shortcut to the above two steps is CTRL+T which will open the Create Table window directly.

Step 5: Now select the entire table and go to Insert and from the Chart Group sets select the 2-D column. You can choose any chart as per requirements.

Step 6: Now we insert new data in the Excel table and observe what happens in the chart.

It can be observed that as we enter the new data the chart gets automatically updated. 

A Dynamic chart range is the range of a data set which automatically updates on any modifications in the original data set. It is beneficial because at some point in time we need to add or delete data from the original data set. So, we want a method to automatically update the chart on performing any modifications in the source data set. This is known as Dynamic Chart Range in which as the source data changes, the dynamic range updates, and within a fraction of seconds the chart associated with the data set automatically gets updated.

In this article, we are going to see how to create a dynamic chart range in Excel. Basically, there are two methods :

• Using the Excel Table made with the data set.
• Using the Formula method.

Let’s consider an example shown below and see how to create a dynamic chart range using the above-listed methods.

Example: Consider the data set shown below which consists of the data about the number of students enrolled in our famous courses. We will create a dynamic range so that if any new data are either added or deleted the chart gets modified automatically.