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

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

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

"Dan" wrote:

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

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

"Steiner" wrote in message
...
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

"Dan" wrote:

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