Is it possible to draw lines in excel

Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Download Drawing a line in Excel Template. Excel Drawing a line By Ashwani Jaiswal. Popular Course in this category. Course Price View Course. Free Excel Course. Login details for this Free course will be emailed to you.

Email ID. Contact No. All of these forms of lines are used as a connector in excel. It is either used to show the relationship or the dependency or the connection in excel. For example, suppose we have various cells with data but which cells refer to which data can be recognized by Inserting Line Shape in Excel.

Suppose we have a chart for data, and we can see that there is a dip in sales for a company. Rather than going through the whole data and analyzing the issue for a viewer, the chart author can simply add text to show the reason for the spike and draw a line in excel to indicate the same.

Suppose we have an illustration such as below somewhere in our data, and we want to show a relation between them,. We will use the Elbow arrow connector in line to show that the main is related to both sub 1 and sub2. Step 2 — Again, as before, a dialog box will come for the various shapes to choose,. Step 3 — This time, we will choose the Elbow Arrow connector, which is located in the fifth position from the start.

Step 4 — Now we know that we need to show a relation between main and the two subs, right-click on the mouse from the main and release the mouse when we drag it to the sub 1 end. Step 5 — This is the first connection; now again, go to the Insert tab and, in illustrations, click on shapes.

It can also be used to draw shapes if it is used in freeform. Draw line in excel acts as a connector as in the above example; it showed the connection between Main and the other two Subs. This has been a guide to Draw Line in Excel. Note: If no connection points appear, you've either chosen a line style that is not a connector, or you are not working on a drawing canvas in Word or Outlook.

Click anywhere on the first shape, and then drag the cursor to a connection dot on the second connection object. Note: When you rearrange shapes that are joined with connectors, the connectors remain attached to and move with the shapes. If you move either end of a connector, that end detaches from the shape, and you can then attach it to another connection site on the same shape or attach it to another shape. After the connector attaches to a connection site, the connector stays connected to the shapes no matter how you move each shape.

Click one location in the document, hold and drag your pointer to a different location, and then release the mouse button. Under Lines , right-click the line or connector that you want to add, and then click Lock Drawing Mode. Click where you want to start the line or connector, and then drag the cursor to where you want the line or connector to end.

Select the line you want to change. To work with multiple lines, select the first line, and then press and hold Ctrl while you select the other lines.

On the Format tab, click the arrow next to Shape Outline. If you don't see the Format tab, make sure you selected the line. You might have to double-click the line. To change the arrow type or size, or to change the type, width, or color of the line or arrow, click More Arrows , and then choose the options that you want. To remove an arrowhead, click the first style, Arrow Style 1 no arrowheads. Click the line, connector, or shape that you want to delete, and then press Delete. If you want to delete multiple lines or connectors, select the first line, press and hold Ctrl while you select the other lines, and then press Delete.

Insert or remove horizontal lines. Draw or edit a freeform shape. Change the color, style, or weight of a line.