NumberFormatLinked Property

Applies To

DataLabel Object, DataLabels Collection, TickLabels Object.

Description

True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). Read-write.

Example

This example links the tick label number format to its cells for the value axis in Chart1.


Charts("Chart1").Axes(xlValue).TickLabels.NumberFormatLinked = True