Creating Charts in Multiple worksheets

I have a worksheet with about 50 tabs and each one has the exact same table references. I would like to create a chart in each tab and with each one referencing the respective table in that tab. Is there a simplified/efficient way to do this without having to going to each individual tab to create that chart?

I have tried creating a chart in one worksheet and copying it to multiple worksheets, but excel will not allow me to paste it. I've also tried selecting multiple worksheets silmutaneously and then creating a chart, but that also does not work.

Anyehlp will be greatly appreciated

Here is a neat way . There is no vba involve.


First go to:

Insert > Name > Define

and input these formulas in


Col_A1

Please Login or Register  to view this content.

Col_B1

Please Login or Register  to view this content.

Shts

Please Login or Register  to view this content.

Then create a chart and right click it and select Source Data and input these:

Values : ='Dynamic Charts1.xls'!Col_B1

Category (X) axis Labels: ='Dynamic Charts1.xls'!Col_A1

Click OK

You'll notice there is no data. Go back to the Define Name range formula say Col_A and click inside the refers to: box and click Ok. Now you see the data in the chart.

Then copy the chart and paste the chart to every worksheets. Then go back to the Define Name range formula to Col_A1 and click inside the refers to: box and click Ok. Now you'll see all the charts are populated with the data.


I left a example workbook below it has all the define name range formulas. Just copy the chart and paste it into every worksheet in the workbook and go to the Insert > Name > Define select Col_A1 and click inside the refers to: and click ok.

Hi vane0326,

I am attempting to insert graphs across multiple sheets and this post of yours is very helpful. But I have different column range and hence I want to know where and how exactly these formulas should be inserted in. I am using excel 2010.

Thanks