Chart based on variable number of columns

#1 05-29-2005, 07:05 PM

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

#2 05-31-2005, 12:05 PM

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

#3 06-05-2005, 10:40 PM

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 <46A3ED1D-4B0F-4F08-957D-6B621FAF059B@microsoft.com>,
BarbR@discussions.microsoft.com 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
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)