| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart datalabels linked to cells
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).form ula="=data!C3" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart datalabels linked to cells
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-Time Chart Only Displays Even DataLabels | Excel Programming | |||
| Chart Datalabels.Position | Excel Programming | |||
| Be able to edit position of datalabels in a protected chart. | Excel Programming | |||
| How to assign datalabels to a scatter chart, obtaining the labels. | Excel Discussion (Misc queries) | |||
| Excel Chart Datalabels | Excel Programming | |||
Linear Mode
