adding a single label on excel chart

  • Thread starter Thread starter Eric_G
  • Start date Start date
E

Eric_G

I have an excel chart with over 300 values. I only wish to add the label for
the LAST value; unfortunately, when I attempt to add the label value, ALL
label values are added. The values are so closely mapped together than I am
unable to individually select this datapoint in order to add the label to the
final datapoint. Is there another way to do this easily?
 
Eric_G -

Regarding "I am unable to individually select this datapoint," you could try
(from a previous post):

"To make a selection, an alternative is to use the arrow keys to cycle among
the chart objects. With a chart selected, the up & down arrow keys cycle
among the major chart objects (not including individual data points), and
the left & right arrow keys cycle among all chart objects (including
individual data points)."

For your situation, to select the last data point, it might be easier to use
up & down arrow keys to select the major chart object after the data series
in the cycle, and then use left arrow key to go back to that last data
point.

- Mike
http://www.MikeMiddleton.com
 
In addition to Mike's suggestion you might give a macro a try. The example
below should work with line and column charts. The areas needed to select
the series and point values fall within the "****" in the code.

To run the macro, activate (select) your chart (select the outside "handles"
with your mouse) and go to Tools -> Macro -> Macros.

Sub Add_Label_To_Last_Point()

Dim SeriesNumber As Integer
Dim PointValue As Integer
Dim Cht As Chart
Dim Srs As Series

'*************************
SeriesNumber = 1
PointValue = 300
'*************************

Set Cht = ActiveChart

Set Srs = ActiveChart.SeriesCollection(SeriesNumber)

Srs.Points(PointValue).ApplyDataLabels Type:=xlDataLabelsShowValue

End Sub
 
Back
Top