how to change the shape of the end of the line
I would like to Cap type . Square, as here
Printable View
how to change the shape of the end of the line
I would like to Cap type . Square, as here
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?Quote:
Originally Posted by .paul.
This is the code for the dash style
for CapStyle ?Code:.Format.Line.DashStyle = 1
I searched and asked many people but nobody knows
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 chartQuote:
Originally Posted by opus
no free-hand
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 triedQuote:
Originally Posted by TysonLPrice
But Excel does not record the CapStyle only DashStyle
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 lookingQuote:
Originally Posted by TysonLPrice
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/
Code:Format.Line.Weight = 3
Format.Line.DashStyle = 1
Format.Line.... CapStyle ???