Creating Same Chart on Multiple Work Sheets

[Prevost]

Hi There. I recently found out that I can make changes on multiple worksheets by selecting the worksheets and making a change on one sheet and it propagates to all the sheets. It is data for each minute of the day so all the worksheets are in the same format. Is there a way to select all the sheets and insert a graph on one which will then propagate to all the other sheets? All the options on the Insert tab are greyed out when I select multiple sheets. Thanks!

 

[ParamRay]

The answer is no.

There's another option if the chart data is in the same cells on each worksheet. In this case you can record a macro while creating the chart on one worksheet and then run that macro on each of the other worksheets...