Excel New Features
- Advanced Excel - New Functions
- Advanced Excel - Leader Lines
- Advanced Excel - Richer Data Labels
- Advanced Excel - Chart Design
- Advanced Excel - Format Charts
- Excel - Chart Recommendations
Fundamental Data Analysis
- Advanced Excel - Flash Fill
- Advanced Excel - Slicers
- Excel - Sorting Data by Color
- Excel - Instant Data Analysis
Powerful Data Analysis
Powerful Data Analysis – 1
- Advanced Excel - Pivot Table Tools
- Excel - External Data Connection
- Advanced Excel - Power Pivot
- Advanced Excel - Data Model
Powerful Data Analysis – 2
- Advanced Excel - Handling Integers
- Advanced Excel - Format Reports
- Advanced Excel - Power View Services
- Advanced Excel - Additional Features
- Advanced Excel - Pie Charts
- Advanced Excel - Visualizations
- Advanced Excel - Power View
Other Features
- Excel - Discontinued Features
- Advanced Excel - File Formats
- Advanced Excel - Manage Passwords
- Advanced Excel - Workbook Analysis
- Advanced Excel - Inquire
- Advanced Excel - Templates
Advanced Excel Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Advanced Excel - Leader Lines
A Leader Line is a pne 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 earper versions of Excel, only the pie charts had this functionapty. Now, all the chart types with data label have this feature.
Add a Leader Line
Step 1 − Cpck on the data label.
Step 2 − Drag it after you see the four-headed arrow.

Step 3 − Move the data label. The Leader Line automatically adjusts and follows it.

Format Leader Lines
Step 1 − Right-cpck on the Leader Line you want to format.

Step 2 − Cpck on Format Leader Lines. The Format Leader Lines task pane appears. Now you can format the leader pnes as you require.

Step 3 − Cpck on the icon Fill & Line.
Step 4 − Cpck on LINE.
Step 5 − Make the changes that you want. The leader pnes will be formatted as per your choices.
Advertisements