Hi everyone,
It's been a while since I last visited this forum. Got a question regarding how to keep the autoshape tags in sync with the data point.
I often draw autoshape tags on top of a line chart & insert brief text to provide further explanations for the up and down movement. As the source data series expand over time, the data points representing the position for each month move accordingly on the chart graph. The tags however do not move.
Would it be possible to make these autoshape arrows move in auto sync with the data points they relate to. For example, if I have a tag on top of the data point for June. No matter how the line graph changes, I want that tag to be always on top of the June data point.
Would appreciate your input & thanks in advance.
Regards
How long and complex is the text in the autoshape, perhaps you could use a data label?
For the arrows you could use custom markers on another series, depending on how much the arrows vary between chart updates.
Can you post an example workbook?
Hi Andy,
Thanks for your reply. 12 characters would be the max length of text (could be shorter if I use acronyms). I now enclose a sample workbook for your reference. Any autoshapes or tags would do.
You mentioned the use of custom markers on another data series. Would you please show me how to?
Many thanks & regards
Last edited by digita; 08-12-2008 at 09:21 AM.
Here is some information on custom markers.
http://peltiertech.com/Excel/ChartsH...omMarkers.html
This example may be what you need
http://peltiertech.com/Excel/Charts/PointAtPoints.html
This is exactly what I'm after. Thanks for such a great help Andy.
Cheers
PS - is there a thread tool somewhere in this forum to mark the thread as being solved?
Last edited by digita; 08-12-2008 at 09:55 PM.
No tool, your post is good enough.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks