S
simonc
I am using an XY chart as a simple map. The data are in
three columns of a worksheet - X coordinate, Y coordinate
and Point ID. On my chart I want to plot the points and
have each labelled with the point ID. At the moment I can
only make the labels show either the X coordinate value
(if I select Show label in the Data Labels tab) or the Y
coordinate value (if I select Show value).
How can I automatically link the label text to the column
with Point IDs?
Grateful for any help.
three columns of a worksheet - X coordinate, Y coordinate
and Point ID. On my chart I want to plot the points and
have each labelled with the point ID. At the moment I can
only make the labels show either the X coordinate value
(if I select Show label in the Data Labels tab) or the Y
coordinate value (if I select Show value).
How can I automatically link the label text to the column
with Point IDs?
Grateful for any help.