Leader lines are lines that connect data labels to their corresponding data points, making charts easier to read and interpret. Initially available only for pie charts, Excel 2013 and later allow leader lines in any chart type, helping to clearly present complex data.
Steps to make Leader lines in a Chart
Given a data set of students and their physics marks. Make a line chart and plot their marks using leader lines.
Step 1: Select a range of cells for which you want to make a line chart.
Step 2: Go to Insert Tab and select Recommended Charts. A dialogue box name Insert Chart appears.
Step 3: Click on All Charts and select Line. Click Ok.
Step 4: A line chart is embedded in the worksheet.
Step 5: Go to Chart Design Tab and select Add Chart Element.
Step 6: Hover on the Data Labels option. Click on More Data Label Options...
Step 7: Format Data Labels emerge on the right-most side of the worksheet. Check the box called Show Leader Lines. Now you can access leader lines.
Step 8: The leader lines will help connect data labels and data points.
