If it's one or two labels, it's easy enough to do it by hand. Add a label to
a single point, then select the label (two clicks to select the single
label), then you can edit its text, or type = in the formula bar and click
on the cell with the value if you want a linked label.
Note that the label sticks to the point number it was assigned to. Say your
chart has ten points and you put the label on the fourth point. If you
change the data range so it starts after the first two original points and
extends two points beyond the original last point, so it's still ten points
long, the point your label was highlighting is now second, but the label is
still on the 4th point (which was the sixth point).
This is a pain, so I will often add a one-point XY series with the values I
want to track, format the point with no marker, and apply a label. This
series doesn't change if the original series is dynamic (the values may
change if the original values change, but it stays latched to the same pair
of cells).
- Jon
