Another reference would be http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/index.html

Depending on what is actually wanted, adapt the ideas in examples 1, 3,
and 4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I'd look through Jon Peltier's Dynamic Chart link to see if anything there is
useful.

http://www.peltiertech.com/Excel/Charts/Dynamics.html

"Scott Hamilton" wrote:

We have a chart that needs to show results ofr a series of years. The number
of years varies based on the age of the client. Is there a way to automate
excel to look for the column containing the appropriate last year and fill
the source data with all columns up to that year