Trying to find Excel VBA code for "round dot" gridline.
April 18, 2010 6:14 PM Subscribe
Excel VBA question: help me insert a "round dot" gridline in my chart.
posted by mullacc to Computers & Internet (8 answers total)
The following line of code inserts a dotted gridline in my chart:
ActiveChart.Axes(xlValue).MajorGridlines.Border.LineStyle = xlDot
But if you change the gridline manually, you have two dotted line options: a faint "round dot" line and a more prominent "square dot" line. The "xlDot" choice in the code above returns the "square dot" style. I want the round dot, but none of the xlLineStyle options
correspond with the round dot style. How do I get that line style?