end label only

  • Thread starter Thread starter Jack Sons
  • Start date Start date
J

Jack Sons

Hi all,

I know how to obtain labels in a graph. What should I do to have only the
"end" label showing? (I mean the label at the end of the line, so with the
largest coordinates)

I know I can "click away" all not wanted labels once they are shown, but
that should be done every time again when the graph is updated in case of
new entries, that is not what I am looking for.

Jack Sons
The Netherlands
 
Andy,

Jon's LabelLastPoint sub does not what I want, it only places the name of
the variable (generally the first cell of the column wirhe the data,
containing the fieldname) at the end of the line, which can sometimes be
more convenient than Excels own legenda.

What I want is different Where Jon places the fieldname/name of the variable
I want to place the y-coordinate of that last datapoint. So the same kind of
data label that Excel would show, but only the "last" one and not al the
others. And when more data is added, I want the label (value of the "last"
y-coordinate) tot shift to the then last point.

Hope I made myself clear, find it difficult to phrase abstract matters like
these.

Andy, anybody else, please help.

Jack.
 
Hi Jack,

I have posted an example using a dummy data series and some formula.
(http://www.andypope.info/ngs/ng17.htm)

Hopefully this will help.

Jack said:
Andy,

Jon's LabelLastPoint sub does not what I want, it only places the name of
the variable (generally the first cell of the column wirhe the data,
containing the fieldname) at the end of the line, which can sometimes be
more convenient than Excels own legenda.

What I want is different Where Jon places the fieldname/name of the variable
I want to place the y-coordinate of that last datapoint. So the same kind of
data label that Excel would show, but only the "last" one and not al the
others. And when more data is added, I want the label (value of the "last"
y-coordinate) tot shift to the then last point.

Hope I made myself clear, find it difficult to phrase abstract matters like
these.

Andy, anybody else, please help.

Jack.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top