Change Chart Data Series Line Format Cap Type in VBA RRS feed


  • The cap type and join type are not exposed in the VBA object model in Excel 2007 and 2010 (I don't know about Excel 2013), so the only way to set them in VBA is using the notoriously flaky SendKeys to control the Format Data Series dialog.

    Regards, Hans Vogelaar

    Tuesday, October 30, 2012 7:56 AM