Melanie -

The way to handle this is with dynamic names, or with VBA. Is there a
problem with using the dynamic names?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"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