Jure
12-19-2009, 02:40 AM
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.
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.