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