Excel line Style

[rampino]

how to change the shape of the end of the line

I would like to Cap type . Square, as here

[.paul.]

is this an excel question or a vb.net question?

if it's excel, try here:

http://www.vbforums.com/forumdisplay.php?f=37

[rampino]

is this an excel question or a vb.net question?

if it's excel, try here:

http://www.vbforums.com/forumdisplay.php?f=37

if I posted in the vb.net section there will be a reason, not believe?

This is the code for the dash style

.Format.Line.DashStyle = 1

for CapStyle ?

I searched and asked many people but nobody knows

[opus]

did you look in here: http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

[rampino]

did you look in here: http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

thank you very much, but I speak of the line of a chart
no free-hand

[TysonLPrice]

Post #12 of this link addresses running macros to generate code and I use it quite a bit. Follow the steps and do the changes you want to a spreadsheet. The code that is generated will be very close but it is still VBA. From that point you can tweak it the way you need.

http://www.vbforums.com/showthread.php?t=391665

[rampino]

Post #12 of this link addresses running macros to generate code and I use it quite a bit. Follow the steps and do the changes you want to a spreadsheet. The code that is generated will be very close but it is still VBA. From that point you can tweak it the way you need.

http://www.vbforums.com/showthread.php?t=391665

Thanks, I had already tried
But Excel does not record the CapStyle only DashStyle

[TysonLPrice]

I'm not sure what you are trying to do but I used Google and found this link. It talks about why you can't do it and then someone pops in with what they say works.

I'm just guessing because I don't do much Excel formatting.

http://www.excelforum.com/excel-char...x-y-chart.html

[rampino]

I'm not sure what you are trying to do but I used Google and found this link. It talks about why you can't do it and then someone pops in with what they say works.

I'm just guessing because I don't do much Excel formatting.

http://www.excelforum.com/excel-char...x-y-chart.html

Thanks, I already read that solution, but it's not what I'm looking

this solution creates problems if I use different versions of Excel, the code has no such problems

In a standard Excel chart you can change the style of the end of the line (see picture)

http://imageshack.us/photo/my-images/824/84309548.jpg/

[rampino]

Format.Line.Weight = 3
Format.Line.DashStyle = 1
Format.Line....  CapStyle ???