Excel Legends. How can I show the line type on my legends?

Originally Posted by mrup096

I am using Microsoft Excel for Microsoft 365 MSO 64-bit.

I don't see any reference to line types in the properties or methods. Here is the spec sheet link:
https://docs.microsoft.com/en-us/off...nd%28object%29

However, I find that it can be manually set in xl2013 by right click in the chart area, the click Format Chart Area and work from the menus that are provided. Still looking for vba method.

After some experimenting, this worked.

Please Login or Register  to view this content.

Line styles are the same syntax for all objects, so you can eaily change them, eg. xlContinuous and xlDouble, etc.
Weight will determine the thickness of the line. Weight = xlThin

As I said previously, these can be set manually.

This is for the legend entries, rather than the border around the legend.

Please Login or Register  to view this content.

The OP was not clear about whether they wanted vba or just a manual procedure. But in vba it looks to me like the ChartFormat object is the key to lines and border formatting. LegendFormat and LineFormat are both part of ChartFormat. Object Browser is not clear on the legend.format but the code works, so that is what matters.