![Advanced Excel Tutorial](/advanced_excel/images/advanced-excel-mini-logo.jpg)
- Advanced Excel Tutorial
- Advanced Excel - Home
- Excel New Features
- Excel - Chart Recommendations
- Advanced Excel - Format Charts
- Advanced Excel - Chart Design
- Advanced Excel - Richer Data Labels
- Advanced Excel - Leader Lines
- Advanced Excel - New Functions
- Fundamental Data Analysis
- Excel - Instant Data Analysis
- Excel - Sorting Data by Color
- Advanced Excel - Slicers
- Advanced Excel - Flash Fill
- Powerful Data Analysis
- Excel - PivotTable Recommendations
- Powerful Data Analysis – 1
- Advanced Excel - Data Model
- Advanced Excel - Power Pivot
- Excel - External Data Connection
- Advanced Excel - Pivot Table Tools
- Powerful Data Analysis – 2
- Advanced Excel - Power View
- Advanced Excel - Visualizations
- Advanced Excel - Pie Charts
- Advanced Excel - Additional Features
- Advanced Excel - Power View Services
- Advanced Excel - Format Reports
- Advanced Excel - Handling Integers
- Other Features
- Advanced Excel - Templates
- Advanced Excel - Inquire
- Advanced Excel - Workbook Analysis
- Advanced Excel - Manage Passwords
- Advanced Excel - File Formats
- Excel - Discontinued Features
- Advanced Excel Useful Resources
- Advanced Excel - Quick Guide
- Advanced Excel - Useful Resources
- Advanced Excel - Discussion
Advanced Excel - Leader Lines
A Leader Line is a line that connects a data label and its associated data point. It is helpful when you have placed a data label away from a data point.
In earlier versions of Excel, only the pie charts had this functionality. Now, all the chart types with data label have this feature.
Add a Leader Line
Step 1 − Click on the data label.
Step 2 − Drag it after you see the four-headed arrow.
![Four-Headed Line](/advanced_excel/images/four_headed_line.jpg)
Step 3 − Move the data label. The Leader Line automatically adjusts and follows it.
![Adjusts Leader Line](/advanced_excel/images/adjusts_leader_line.jpg)
Format Leader Lines
Step 1 − Right-click on the Leader Line you want to format.
![Format Leader Line](/advanced_excel/images/format_leader_line.jpg)
Step 2 − Click on Format Leader Lines. The Format Leader Lines task pane appears. Now you can format the leader lines as you require.
![Format Leader Line Pane Appear](/advanced_excel/images/format_leader_line_appear.jpg)
Step 3 − Click on the icon Fill & Line.
Step 4 − Click on LINE.
Step 5 − Make the changes that you want. The leader lines will be formatted as per your choices.
To Continue Learning Please Login