Charting only partial data from a large dataset

[forest8]

I have a large data set which I update monthly. The monthly data are in
columns -- the rows are employees. Each month their sales figures are added
in the next available column. I have at least 5 years (i.e. 60 months of
data).

I only want to chart for selected employees their sales for 2 years but not
necessarily the most 2 years.

How would I go about setting this up? Currently I update the charts
manually but I can't go back and look at different timeperiods.

Any help will be greatly appreciated.

 

[Jon Peltier]

This is a complicated problem, but I wrote an article which may help you
through it:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon

 

[forest8]

This worked great. Thanks.

This is a complicated problem, but I wrote an article which may help you
through it:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______