View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default Dynamic change of chart source

Yes, the links below will take you to examples that show you how to create
dynamic charts:

http://peltiertech.com/Excel/Charts/...hartLinks.html

http://pubs.logicalexpressions.com/p...cle.asp?ID=518

--
John Mansfield
http://cellmatrix.net





"QM" wrote:

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