Hi Melanie

If you do not want to use dynamic names and you do not mind a macro doing
the job for you once a month, then...
1) Create a list of the names of each chart in, say, a new worksheet - name
the range, (without inverted commas), "chartlist".
2) In the column to the right ot your "chartlist" range, enter the source
data range for each chart (eg B2:M3)..
3) In the third column, enter the sheet name where the chart is located.

Then try the following code.....

Sub ChartRangeTest()
Dim c As Range, r As Range
Set r = Sheets("Sheet2").Range("chartlist")
For Each c In r
Sheets(c.Offset(0, 2).Text).ChartObjects(c.Text).Chart.SetSourceData _
Source:=Sheets(c.Offset(0, 2).Text).Range(c.Offset(0, 1))
Next c
End Sub

--


XL2003
Regards

William



"Melanie Martin" <Melanie wrote in message
...
Is there any method other than using Dynamic Names/OFFSET to force a chart
to
always use specific columns and rows, regardless of whether or not new
ones
are added.

We have multiple spreadsheets that track monthly metrics. Each month a
new
column is added representing a new month of data. I always want to show
columns B-M to refelct the past twelve months. Currently when I add a new
column representing a new month,the charts dymanically change to show
columns
C-N and I have to change over 20 charts back to B-M.

Thanks!
Melanie Martin