Using Excel 2003, I am trying to write have should be a simple VBA script to
display the value for the last item in a data set. The macro works fine on a
"normal" chart. Where I have having trouble is on a chart depicting the
running total of a pivot table. Nothing appears when the macro is run. When
I highlight the data point, the labels for the data point appear as pop-up
text, however, no value is displayed (like in a normal chart). When I
display all data labels, they all appear. Is there a way to programatically
get this value?