Excel 2007 graphs/charts automatically populate with new data

[Tony O]

I am working with multiple charts in Excel 2007. The charts are
filled in with pivot table data.

Every time a new month is added, the data is located one column to the
right of the old data.
In order for me to add the new month, I have to go manually into each
chart, add a new month,
and up the range to the corresponding columns.

How can I get Excel to automatically find the data in the pivot table,
and increase the range so it
populates the graph with the new month name and data? Please detail
how to do this.

 

[Zaidy036]

I am working with multiple charts in Excel 2007. The charts are
filled in with pivot table data.

Every time a new month is added, the data is located one column to the
right of the old data.
In order for me to add the new month, I have to go manually into each
chart, add a new month,
and up the range to the corresponding columns.

How can I get Excel to automatically find the data in the pivot table,
and increase the range so it
populates the graph with the new month name and data? Please detail
how to do this.

Simple methods?
1. New month always in the same column on the left, move old data one
column right.
2. Place Data for graphs in a named location and copy the month's data
into it.