If you are using Excel 2003 or above you can create a data table (or list) from the chart’s source data. The easiest way to make charts with dynamic ranges

Ofcourse not, there are 2 ways to do this. Well, you can do it very easily using excel formulas and named ranges. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows? You cant edit the chart input data ranges every time you add a row.

We all know that to make a chart we must specify a range of values as input.īut what if our range is dynamic and keeps on growing or shrinking.