Chart datalabels linked to cells

  • Thread starter Daniel Bonallack
  • Start date
D

Daniel Bonallack

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Chart Datalabels 6
Excel 2007 Data Labels 7
Automatically selecting active chart 4
Data Labels Macro 4
Excel 03 to Excel 07 1
Adding Chart problem 0
DataLabels 1
add a chart in a Add-In 1

Top