You cannot use VBA code to configure the Cap Type and Join Type properties in Excel

Article translations Article translations
Article ID: 2755172 - View products that this article applies to.
Expand all | Collapse all

Summary

You cannot configure the Cap Type and Join Type properties for line styles in a chart by using Visual Basic Applications (VBA) code in Microsoft Excel. You can only configure these properties by using the settings in Excel.

Note Line styles include borders, series and trend lines, marker lines, and any other object that has the Cap Type property.

More information

The Cap Type and Join Type properties do not have corresponding object model properties that you can use in VBA code. Additionally, by default, the Cap Type and Join Type properties are set to Round.

Properties

Article ID: 2755172 - Last Review: November 30, 2012 - Revision: 1.0
Applies to
  • Microsoft Excel 2013
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
Keywords: 
kbsurveynew kbexpertiseinter kbinfo kbprb KB2755172

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com