LastPointLabel

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

Jon,

I have successfully run the LastPointLabel macro. Three
line series have been properly labeled. Two series are
simply straight lines across the chart, and the third
series is one year's worth of data on a two-year variable
data plot. After running the macro, a label was inserted
at the end of the data plot; however, when data was
entered for the next point, the label remained a text
description, rather than a numeric value. The new point
shows numeric value.

Another thing - if I delete the label on the variable
series and enter data for the next point, I have a missing
label, obviously.

I guess my question is: is this macro intended as a
dynamic event or something one runs at the end of a series
plot?

In any event, if we could add a feature to select which
series to label, it would help.

Thanks,
Phil
 
Phil -

The code I posted is a mere toy compared to Rob Bovey's Chart Labeler
(http://appspro.com). He links the cells to the labels, while I merely
put text into a label. He picks up the cell's formatting and applies it
to the labels. His utility allows you to (manually) select a point to
label, mine just brute forces its way through the chart. If I update
the data, I know I have to delete the labels and rerun the macro. But I
don't really need my charts to be dynamic in many of my own uses (a lot
of rear view glances at the data), so I haven't bothered to add features.

To label just a single series, you could simply select the last point,
add a label from the format dialog (Ctrl-one), and edit the text. Or
select the rectangle representing the label, press the equals key, and
click in the cell you want to use for the label. Or use Rob's Labeler,
select the series, then the point, and apply the label.

- Jon
 
Back
Top