Auto dynamic Chart

[vickyho1008]

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