View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Labeling Data Series on an XY Scatter

Select the point you want to label (two single clicks, one for the series,
one for the point itself). Press Ctrl+1 to format the point, then add a data
label using the Series option. This point will carry the series name as its
label, even if the data or the series name change.

In 2007, select the point (two clicks again). Go to the Chart Tools Layout
tab, click on Data Labels More Data Label Options, choose the Series Name
option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Dan" wrote in message
...
I need to label a data series on an XY Scatter. Currently Excel only has
the
option to label and individual point with the series name, I want to label
the entire series of points just once with the series name, even if inputs
are changed.