Wednesday, April 3, 2013

Creating dynamic range plots in Excel

What are dynamic range charts ?

In a chart we must specify the range from which chart need to be plotted. However, in some situations we want a dynamic range - the range of data input either grow or shrink -

Dynamic range charts are such charts that updated automatically if  input data range is changed.

Then how can we do that ?

In excel 2003 or above you can create a data table,  with table if you add or remove any rows the chart gets automatically updated.

Creating a table in Excel 2013:

 Click format at table after selecting the region of interest.

Once clicking OK, the sheet works as dynamic range. For example I added some X variables and the plot got updated automatically.

Perhaps the above is simpler way to create a dynamic range. You can also use Offset function.

No comments:

Post a Comment