vba add arrow to chart series line

[erfigge]

I have office 2007 and would like to add an arrow to the end of the series line. It can be done by right clicking the series and formatting the line style:arrow settings. However, macro recording does not pick that up. I have files that work with hundreds of charts so I really need to do that by vba. Anyone know how to do that?

Thanks.