John -
You can also apply a label to an individual point, instead of the whole
series. Select the point (requires two single clicks), then use my
favorite shortcut, Ctrl+1 (numeral one) to open the Format dialog. On
the Data Labels tab, add the style of label you want for this point,
presumably Value.
If you already have the labels, you can selectively delete one. Select
the individual label (two single clicks, like selecting the single point
above), and press Delete.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
John Cordes wrote:
> While walking home from a lecture this evening I thought of the very
> simple solution to my problem. Just add a third data Series to the chart
> with only the right hand end point - label it and voila!
>
> John
>
> John Cordes wrote:
>
>> As a final finishing touch I'd like to have a label (1.80 to 2
>> decimals) placed at the right end of the line. All I've been able to
>> come up with so far is to have the two data labels plotted, but then
>> the number 1.80 appears both at the left and right end of the line;
>> the one on the left is on the right of the data point and so
>> overwrites the horizontal line (I just have the line showing, not the
>> data points). Doesn't look very good.
>> John
Bookmarks