ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie chart with 'anchored' lines to text box (https://www.excelbanter.com/charts-charting-excel/24830-pie-chart-anchored-lines-text-box.html)

TOMB

Pie chart with 'anchored' lines to text box
 
I have a pie chart with a text box (to the upper right). I take one slice and
draw lines from the top and bottom of the outside ends of the slice to
connect to the text box.

Naturally, as the data changes, the slice changes (or the pie slightly
rotates) which requires me to adjust the lines to the box.

Is there a way to have these lines track with the chart?


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com