Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Leader Lines Connecting Chart to 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? |
#2
|
|||
|
|||
Hi,
Here is a possible solution. It uses a combination chart which allows the lines to be plotted and updated dynamically by using a xy-scatter. http://www.andypope.info/charts/customerleaderlines.htm If you have to still with using the drawn lines then you will have to use VBA code to re position the lines according to the new data. Cheers Andy TOMB wrote: 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? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
Pie chart with 'anchored' lines to text box | Charts and Charting in Excel | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
Can a line(s) be added to a stacked-clustered chart? | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |