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