• 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:

  • Lookup Multiple Values in Excel
    Lookup Multiple Values in Excel
  • SEQUENCE Function in Excel
    SEQUENCE Function in Excel
  • Create a Picture Lookup in Excel
    Create a Picture Lookup in Excel
  • Shrinking Drop-Down List using Dynamic Array Formulas
    Shrinking Drop-Down List using Dynamic Array Formulas

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
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 2020 Computergaga · All Rights Reserved ·