Thread: Xl 2007 VBA applying round dot format to chart series

Hi,

Does anyone know the syntax for formatting a chart series plot line as 'round dot'.

I've tried all sorts of variations and additions to

Code:

Activechart.SeriesCollection(2).format. .......

with no luck and most unhelpfully the macro recorder is no use.

Also tried intellisensing via the MS help, but it must be me since no help is forthcoming. I've seen references by Andy and Jon in other areas of the web which seem to suggest some are harder to discover than others.

Is there a document anywhere which summarises this sort of stuff?

Usual TIA

Ah.... re the last post.

I've found the syntax....

Code:

Activechart.SeriesCollection(2).Format.Line.Dashstyle=msolinerounddot

seems to work. Now all I want to find is the instruction that sets the width of the dots.....

Rgds

try,

Code:

    objSeries.Format.Line.Weight = 12

Cheers Andy,