Creating Multiple Excel Charts

[houstonguy]

Is there any easy way to create charts in excel? I have 24 graphs (on
one page) to create and show actual and budget data on a line graph,
the actual and budget data are on separate tabs. It is for a rolling
24 months time frame, and I have to have similar graphs for four
locations. Is there an easy way of doing this? I tried doing the
name ranges, but this will require too many named ranges.

Thanks.

 

[Don Guillett]

Do you need 24(x 4?) or will one that you can change the month to display.
More info