G
GeoBrooks
I've used the technique outlined at
http://peltiertech.com/WordPress/connect-two-xy-series-with-arrows-vba/ to
draw lines on an embedded chart in XL2007. But I've had to add 4 to the
calculated coordinates to make the lines connect to data points. This offset
seems to be independent of chart size.
Is there a chart property from which this offset can be derived? Or is this
just a "feature"?
George
http://peltiertech.com/WordPress/connect-two-xy-series-with-arrows-vba/ to
draw lines on an embedded chart in XL2007. But I've had to add 4 to the
calculated coordinates to make the lines connect to data points. This offset
seems to be independent of chart size.
Is there a chart property from which this offset can be derived? Or is this
just a "feature"?
George