Chart based on variable number of columns

[Scott Hamilton]

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

 

[Barb R.]

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

 

[Tushar Mehta]

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