Auto expanding x axis of a chart.
 

Hi,
I'm having the following problem: I have a chart that shows date's on
the x axis and a other value on the y axis. When you add a new date in
the excel sheet it add's that date on the x axis. But when I've added
enough date's the chart gets cludderd up (all the value's standover
each other).

I want the chart to expand automatic to the right when more date's are
added. The amount of date's that will be added is unkown, but it can
be alot. So the chart has to "grow" from narrow to a long stretched
chart.

Is there a way I can do this?