VBA to help when pasting charts with absolute cell references into additional worksheets

[halesowenmum]

Does such a thing exist?

I have a dashboard consisting of doughnut charts and a trend graph. Each worksheet is for each person on the 10 person strong project team. On each worksheet there are 36 doughnuts which reference various cells containing the source data, located on that worksheet.

In Cols J thru U are the doughnuts, repeated a total of three times going down the sheet.

So for January a specific 4 cells are reference, for February another specific 4 cells etc - it's the same each time and I've set up the first worksheet so that all the doughnuts are referenced perfectly and all works fine.

However, when I copy and past the worksheets nine times to cover off all the remaining team members, of course the chart data formulas reference my first worksheet meaning I'd have to manually edit every single doughnut chart's worksheet references.

Is there a bit of VBA I can slot in that would handle this at all?

If anyone can help I'd be so grateful.

 

[njimack]

Take a look at https://peltiertech.com/change-series-formula-improved-routines/

 

[halesowenmum]

Take a look at https://peltiertech.com/change-series-formula-improved-routines/

Thanks, having a look now - let me see how I get on - thank you.

 

[halesowenmum]

Well, you get the gold star for sure - how easy was that! Absolutely perfect, thank you so much.

I look at a lot of Peltier stuff but hadn't come across this one before.

Thanks so much for sharing the link.