Display Data Labels for only the First and Last Data Points

[3link]

My graph looks like this:

Basically, I want to get rid of the center labels for the red and blue lines (series). This is a dynamic graph and the value will vary by user input. Thus, I can't simply delete these labels and fix the problem. I need to set-up excel so that only the first and last values of the two series have labels. The end result would look like:

Is this possible? A VBA solution would be great. Thank you.

 

[Jon Peltier]

The routine in this article finds the last label-able point in each series of a chart. You could modify it to also label the first point of each series.

http://peltiertech.com/WordPress/label-last-point-for-excel-2007/

 

[3link]

The routine in this article finds the last label-able point in each series of a chart. You could modify it to also label the first point of each series.

http://peltiertech.com/WordPress/label-last-point-for-excel-2007/

Thank you for this.

I'm having trouble modifying it to include both first and last. I'm able to change it between first and last by changing the value of the negative number that comes after "Step", but that's it thus far. This will be a learning experience.

 

[Jon Peltier]

Only loop once. In my situation, it is the last point which is hardest to identify, so looping from the last forward made the most sense. After the loop labels the last point, explicitly label the first.