Creating Charts with varying X/Y-axis data lengths

Hi,

Firstly, thanks to everyone that posts on this forum.

I woud like a macro that creates a chart, but there is an additional complecation.

- The length of the data can change each time I run the macro. For example, the x-axis ("Date") may be 30 observations one run, and then 300 observations the next.

Any code suggestions / help would be great!

Thanks,
Lewis

cool,

thanks.