Auto dynamic Chart

I would like to generate a chart which will automatically update with the latest number I enter, but the length of this set of number to be charted varies. The scale of both axis will vary too.

Please see attached example, in Column B-D, I will input the monthly return for the fund and the 2 benchmarks, and Column G-I calculate the corresponding NAV. The chart's x-axis reads from Column A and y-axis from Column G-I.

In this spreadsheet, from time to time, Column B-D will be replaced with different fund and benchmark, i.e. Fund 1 starts from May 99 - Oct 06, another fund may start from Jan 05 etc.. How can I make the chart to be dynamic and automated? as well as the scale to be adjusted automatically?

many thanks

chart scales will update automatically...

visit peltiertech.com for how to construct dynamic charts.

If a data set includes the value #N/A (not applicable) the Excel charts will ignore that value but plot everything around it as normal.

A cell can be set to #N/A using the =NA() function.

Try setting up some "dummy" cells with the value #N/A at the end of your existing data. Include these dummy cells in the data range plotted on the chart. If you insert cells between the real data and the dummy data the chart will automatically extend the range of cells plotted to include the new cells.

Alternatively, if you know the eventual maximum data set size, set up the full range of cells with #N/A then overwrite as the new data becomes available.

Mark.