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