Prev: Thank you very much!
Next: WorksheetFunction Calculation Error
From: Daniel Bonallack on 9 Mar 2010 13:34
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.

Problem:
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 22 Mar 2010 22:37
Excel 2007
Points().DataLabel.Text
http://c0444202.cdn.cloudfiles.rackspacecloud.com/10_31_09a.xlsm
 | 
Pages: 1
Prev: Thank you very much!
Next: WorksheetFunction Calculation Error