Site icon Best Excel Tutorial

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

Just click ok.

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

Once the table is created and the scatter chart is inserted, any data you add to the table will automatically be included in the chart.

Add new data to the table created in Step 1. The scatter chart will dynamically update to reflect the changes.

You can download free chart template here

For even more control over dynamic ranges, consider using named ranges with the OFFSET and COUNTA functions.

Exit mobile version