Equivalent to choosing the Data Labels command on the Insert menu when a chart is active. Specifies label contents and position.
Syntax
DATA.LABEL(show_option, auto_text, show_key)
Show_option is a number that specifies what type of labels to display.
Show_option Type displayed
1 none
2 Show value
3 Show percent
4 Show label
5 Show label and percent
Auto_text is a logical value that corresponds the Automatic Checkbox in the Data Labels dialog box. If TRUE, resets a chart's data labels back to their actual values. If FALSE, they are not reset. The Automatic Text checkbox appears only if the label has been selected and its value changed.
Show_key is a logical value that specified whether to show the legend key next to the label. If TRUE, displays the legend key. If FALSE or omitted,does not display the legend key.
Related Functions
List of Command-Equivalent Functions