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.
The table
Click on insert (1) and then choose table (2).
Just click ok.
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.
A scatter chart
Click on insert (1), and then click on scatter chart (2).
Add data to the table created in step 2, and the chart would be dynamically changing.
