Chart Help - Excel 2007

[Doogs2009]

I have multiple data sets to chart from one data source. I have to create a chart for 21 different ID numbers, with each number containing 12 Months across the page in columns, plus 85 rows of data down the page in rows. Excel wont allow to graph the whole lot at once because it exceeds the 255 maximum characters restriction.
However, I would like to create one of the charts first, for example ID #1, then somehow duplicate that chart for the remaining 20 id numbers. The sequence my id numbers are S1 - S21.
Rather than have to create 21 individual charts for this data, is there a shortcut in Excel or a Macro that i can run to just change the data area within the chart for each ID number. Just to add, the data set for each ID number S1-S21 is identical except for the actual dollar amounts, but the charting criteria is the same for each one. If anyone can help me do this I would be really thankful.
Regards
Craig

 

[Steve=True]

Perhaps you can base your chart on a Pivot Table and filter your pivot table for the 1st ID and roll through them all that way one at a time.


Steve=True
www.exceldashboardtemplates.com