Dynamic change of chart source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a chart on one of our many reports that shows the last twelve months
of data presented in a bar graph.

Is there a way to have the source position change dynamically do I do not
have to move the sourcing information on the chart every month.

As an example, the data is formatted like:
A B C D
2006.... 01/2007 02/2007 03/2007 04/2007
100 200 150 175

The starting point of the last twelve months is dependant on the current
reporting month which is always 10 days after month end. The data starts at
2005 through current 06/2007.

Thanks in advance,

Jeremy
 
Back
Top