Multiple charts

[Guest]

I have 5 identical worksheets with different data contained in the cells.
Instead of making 5 charts individually is the a way of selecting all the
worksheets and making a chart on one of the worksheets but then it
automatically makes the identical charts in the other selected worksheets.
This would save me a lot of time.... or is this only possible by writing a
macro and if it is.... i dont know how to...

thank you in advance

 

[Dan]

Is it possible to make the chart on the first worksheet, copy that
worksheet and then paste the data into the copy? Then repeat?

 

[Guest]

Yes well i know how to do that i was just thinking that there might be a way
of just doing one chart for all worksheets so that i would save time. thanks
for the help though

 

[Don Guillett]

why not save the overhead and DO have just one with variable ranges
controlled by a double click macro on the range list.