Dynamic change of chart source

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top