Labeling Data Series on an XY Scatter

[Dan]

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.

 

[Jon Peltier]

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

 

[Dan]

I have another issue... I understand that label but I need to assign the
series label to the left most data point that is plotted on the chart. Is
there an if statement that can test this then place the label next to that
data point?
Basically the label is correct but the data point that I want the label next
to varies.

 

[Jon Peltier]

There are two options that don't require a bunch of VBA.

1. Assign labels to all points. linking the labels to cells in the
worksheet. In these cells, have some kind of formula that determines if a
cell is the leftmost, and if so the label is whatever it should be,
otherwise the label is blank. Use one of these free utilities to link a set
of labels to a range of cells:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

2. Use another series which has X and Y values for only the leftmost point
of each series. Add the appropriate labels to this series, and hide the
points by using no line and no markers.

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