Label at the end of Stacked Bar Pivot Chart

[PopSix]

I have a stacked bar pivot chart. I would like to add a label or textbox at the end of each of the bar. How do I find and reference the x-y coordinates for the end each bar?

My VBA is limited, but growing. Any snippet or code example would be great.

Thanks.

 

[RoryA]

Adjust this line:

Set ser = ActiveChart.SeriesCollection(9)

to this:

Set ser = ActiveChart.SeriesCollection(ActiveChart.SeriesCollection.COunt)

 

[PopSix]

Rory,

Thanks. This was cool. I guess that I was not clear. Sorry. I do not want to over right the value in the last of the series. I want to leave all the data labels of each portion of the stack intact. I want to add a total or text to the end, or just below, the end of each bar.

Thanks,
Don