Set chart line termination with VBA code in excel 2007

[Jure]

I would like to ask, if it is possible somehow set style of chart line termination (cab style) with VBA code in excel 2007.

I excel 2007 line of XY chart have new property. Ends (terminations) of its lines can have three styles – flat, round, square. Round style is set as default. I have chart with 250 lines with width 25 pix (see attachment). In this case terminations of lines have significant impact and it is impossible to make it manually.

Thank you in advance.

[Bob Phillips]

Can you post your workbook for us to see?

[Jure]

Here it is

[Bob Phillips]

What is it that you are trying to do, want to do?

[Jure]

Same thing what you can see on video (attached rapid-link), but with VBA code. Sorry for strange language in the video. (get before link http)

rapidshare.com/files/324111169/Line_termination.avi.html