Align autoshapes with related data points on chart

		Excel Help Forum > Usenet Groups > Excel Charting
Align autoshapes with related data points on chart

Notices

Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Thread Tools

Search this Thread

Rate Thread

Display Modes

08-12-2008, 01:03 AM

digita

Registered User

Join Date: 31 Oct 2007

Posts: 19

Align autoshapes with related data points on chart

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

08-12-2008, 05:20 AM

Andy Pope Andy Pope is offline

Forum Moderator

Join Date: 10 May 2004

Location: Essex, UK

Posts: 2,141

Andy Pope will become famous soon enough

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?

__________________
Cheers
Andy

08-12-2008, 09:17 AM

digita

Registered User

Join Date: 31 Oct 2007

Posts: 19

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

Attached Files

example.xls (15.5 KB, 2 views)

Last edited by digita; 08-12-2008 at 09:21 AM.

08-12-2008, 12:39 PM

Andy Pope Andy Pope is offline

Forum Moderator

Join Date: 10 May 2004

Location: Essex, UK

Posts: 2,141

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

__________________
Cheers
Andy

08-12-2008, 08:45 PM

digita

Registered User

Join Date: 31 Oct 2007

Posts: 19

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.

08-13-2008, 07:19 AM

Andy Pope Andy Pope is offline

Forum Moderator

Join Date: 10 May 2004

Location: Essex, UK

Posts: 2,141

No tool, your post is good enough.

__________________
Cheers
Andy

Bookmarks

New topics in Excel Charting

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Forum Jump

All times are GMT -4. The time now is 07:43 PM.