Charting only partial data from a large dataset

  • Thread starter Thread starter forest8
  • Start date Start date
F

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.
 
Back
Top