How can I draw a line in Excel?

How to Draw a Line in Excel

  1. Open Excel and click the “Insert” tab. Video of the Day.
  2. Click “Shapes” in the “Illustrations” section.
  3. Click the first button on the left under “Lines.” This is the “Line” button.
  4. Click and drag to draw the line.

Where are drawing tools in Excel 2010?

How to Use Drawing Tool in Excel? We must first go to the “Insert” tab in the Excel toolbar. Then, choose a drawing object which we want. If we want to insert a shape, we must click on “Shapes.”

How do you add a horizontal line in Excel 2010?

In the chart, select the data series that you want to add a line to, and then click the Chart Design tab. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Click Add Chart Element, and then click Gridlines.

How do I draw a vertical line in Excel?

Insert vertical line in Excel graph

  1. On the All Charts tab, select Combo.
  2. For the main data series, choose the Line chart type.
  3. For the Vertical Line data series, pick Scatter with Straight Lines and select the Secondary Axis checkbox next to it.
  4. Click OK.

How do I combine a bar and line graph in Excel 2010?

Excel 2010 – Create a Combo Chart

  1. Select the Cells. Select the cells containing the headings and numbers to be included in the chart.
  2. Insert a Column Chart. Click the Insert tab on the Ribbon.
  3. The Column Chart.
  4. Change One of the Bars (to a Line)
  5. Display the Scale for the Line on Secondary Axis (Optional)

How do I add a line between columns in Excel?

If you’d like to add a vertical line between the columns, open the Columns dialog box.

  1. Choose Page Layout > Columns. At the bottom of the list, choose More Columns.
  2. In the Columns dialog box, select the check box next to Line between.

Can you freehand draw in Excel?

When a freehand object is selected, Excel will display a Drawing Tools Format menu within the menu interface known as the Ribbon. You can add additional freehand objects by choosing the Scribble tool from the palette at the start of the Drawing Tools Format tab.

Why won’t Excel let me draw?

If the Draw tab options are greyed out only in a specific file, and the drawing feature works fine in other files and Office apps, it is possible that the file in concern is corrupted. Try repairing the affected workbook first, and see how it goes. For instructions, see Repair a corrupted workbook.