Charting only partial data from a large dataset
 

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.

Charting only partial data from a large dataset
 

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

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"forest8" wrote in message
...
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.

Charting only partial data from a large dataset
 

This worked great. Thanks.

"Jon Peltier" wrote:

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

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"forest8" wrote in message
...
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.