Leader lines excel updating
See screenshot: You also can change the leader lines formatting by changing the line style or glow and soft edge.
This effect is created by using a combination chart, pie and xy-scatter, and some math formula.
If you want to change the leader lines color, you can go to Format leader lines in Excel.Below is all the data and formula required to create the chart.The highlighted cells contain the actual charted data.Use the source data to specify the location of data, B2: B6, and labels, A2: A6, for the pie chart. Set the minimum and maximum value to -1 and 1 respectively.
The only problem with the chart in its current configuration is that the area available for the leader lines is restricted to the plot area, which is too close to the edge of the pie chart.
It is helpful when you have placed a data label away from a data point. The leader lines will be formatted as per your choices.