how do I draw a dotted line

[blank flange]

I wish to draw a dotted or dashed line in excel, how do I do it

 

[Gav123]

Hi,

If your drawing toolbar isn't visable, click View>Toolbars and select
Drawing from the list.

Select the line icon and draw your line where you want it, then right click
on the line and select Format Autoshape, in the Colors and Lines tab you can
adjust how your line looks.

Hope this helps,

Gav