If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Locking object to data points
How can I lock an arrow & text to a particular data point? In a time series
graph, every time I add new dates, currently the arrows pointing to particular data points for particular dates have to be moved manually. |
#2
|
|||
|
|||
Locking object to data points
On Jan 28, 10:00*am, CheriC wrote:
How can I lock an arrow & text to a particular data point? *In a time series graph, every time I add new dates, currently the arrows pointing to particular data points for particular dates have to be moved manually. Here is onne way which doesn't do exactly want because there are no arrows but you might like to look at it. Download the free add-in XY Chart Labeller and use it to manually label a point. This label will stay with the point even if the graph changes. xt |
#3
|
|||
|
|||
Locking object to data points
Hi,
Create another series where you use custom markers to hold the arrows. http://peltiertech.com/Excel/Charts/PointAtPoints.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "CheriC" wrote in message ... How can I lock an arrow & text to a particular data point? In a time series graph, every time I add new dates, currently the arrows pointing to particular data points for particular dates have to be moved manually. |
Thread Tools | |
Display Modes | |
|
|