How do you tell a Chart Border to have the Join Type "Miter"?
I've recorded a macro (several), but this piece of info doesn't show up?
How do you integrate this:
Please Login or Register to view this content.
.JoinStyle = LineJoinStyle.Miter
I started of with Jon Peltier's "Resizing and Moving Excel Charts with VBA":
https://peltiertech.com/Excel/Charts...oveAChart.html
Thank you, Jon!
Then I recorded a macro for color and weight of the line, but I can't figure out the joint type/style.
Last edited by briskie; 03-19-2024 at 07:29 PM.
Excel's object model does not have a JoinStyle property for the Line object, so I don't think this line modification is possible.
Artik
Oh, ok. So only possible to change manually?
It does show up in the Object Browser.
The prefix "mso" in the names of constants "says" that such constants are declared (are available) at the level of the entire Office suite. But this does not yet mean that they can be used in every application of the suite. A quick web search shows that the JoinStyle property can be used in Publisher, but not in Excel.
Artik
Hi Artik.
Oh, ok. Alright. I didn't find that – thank you for explaining!
Toni
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks