Making Repetative Charts

[Weyoun7]

Is there an easy may to make a series of charts that are similiar but with different data? For instance, if you plotted monthly data and you need to make a new chart each month that is formatted the same.

Presently I copy the old month to a new worksheet and change the source data locations. However, all the header/footer data is lost and must be restored for each new month.

There must be an easier way.
Thank's

 

[Mark W.]

Consider using a PivotTable/PivotChart.

 

[plettieri]

You should be able to uses a marco that keeps all the header and footer data.... Does the header and footer data changes each month? If it stays the same...should not be a big issue..if it changes then you might be able to put a pause in your macro for the variable info.... I think a short bit of code might do this......I pass it along to the code people...

good luck
pll