• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Charts / Add Drop Lines to a Line Graph in Excel

Add Drop Lines to a Line Graph in Excel

Add drop lines to a line graph in Excel to connect the data point to its label on the axis. This extra visual chart element can make it easier to view the data on busy charts.

Take the line graph below for instance that shows the call volume for 14 hours of a day. It can be awkward on this chart to quickly view the time of day for a specific data point.

Line graph with call volume data

Add Drop Lines to a Line Graph

To add drop lines to this line graph in Excel;

  1. Click the Design tab under Chart Tools on the Ribbon.
  2. Click the Add Chart Element button.
  3. Select Lines and then Drop Lines.
Add drop lines to a line chart

The image below shows the chart with drop lines added.

Line chart with drop lines

Add Drop Lines to a Line Graph in Excel 2010 and Earlier

Drop lines are not a new feature, and can therefore be added in older versions of Excel also. In Excel 2010;

  1. Click the Layout tab under Chart Tools on the Ribbon.
  2. Click the Lines button and then select Drop Lines.
Add drop lines in Excel 2010

Watch the Video

Related Posts:

  • Sort by Drop Down List in Excel
    Sort by Drop Down List in Excel
  • Lookup Multiple Values in Excel
    Lookup Multiple Values in Excel
  • Advanced Excel Skills
    Advanced Excel Skills
  • Moving Average in Excel
    Moving Average in Excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • LIVE Currency Exchange Rate in Excel
  • N Function in Excel
  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·