How to Make Dynamic Range Chart in Excel

A dynamic range chart in Excel allows the data in the chart to update automatically when the underlying data changes. This is useful when you have a large dataset that is constantly being updated and you want the chart to reflect these changes without having to manually update the chart.

The table

It is very easy for you to add a dynamic range to a chart. We are going to go through this, in a step-by-step format.

Click on insert (1) and then choose table (2).

ribbon insert table

Just click ok.

Dynamic Range create table

Note: If you click on the beginning of the data, it will automatically choose all the range. If it does not, you can change it yourself. Otherwise, just follow the step.

A scatter chart

Click on insert (1), and then click on scatter chart (2).

insert scatter chart

Add data to the table created in step 2, and the chart would be dynamically changing.

dynamic range to chart excel

Your chart will now dynamically update whenever the underlying data changes. This can save you a lot of time and effort and make your data analysis more efficient.

You can download free chart template here

See also  How to Make a Chart with Subcategories