From: Daniel Bonallack on
I have an old Excel 2003 macro that duplicates a sheet with a column chart on
it. The column chart has data labels that are linked to cells in the sheet.

Now that we're in Excel 2007, the datalabels on the chart on the duplicated
sheet still refer to the original sheet.

So we want to adjust the macro so that the labels point to the same cells on
the active sheet.

Can someone just give me the syntax?
e.g. Activechart.Seriescollection(1).datalabels(1).formula="=data!C3"

From: Herbert Seidenberg on
Excel 2007