How to Add Dynamic Range to Chart?

It is very easy for you to add 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.

create table

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

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

You can download free chart template here