[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

For a non-programmatic solution check the the 'Dynamic Charts' page of
my web site.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office


In article , randellj1
@hotmail.com says...
Good Day,

How can I use a Macro to create charts which would have
different series length. Thus, it would create a chart for
10 yr period then witha change of data re-create a chart
for a 2 yrs period ...and so on.

Thanks for all your help
Llednar