| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding pinned arrows to a chart
Hi! Is there any way to add an arrow that points to a specific coordinate in the chart, even if it resizes? I want to point out interesting things in a chart I have. -- RealRaven ------------------------------------------------------------------------ RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058 View this thread: http://www.excelforum.com/showthread...hreadid=567787 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding pinned arrows to a chart
1) click on chart
2) from Drawing tool select the line with arrow 3) draw line best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "RealRaven" wrote in message ... Hi! Is there any way to add an arrow that points to a specific coordinate in the chart, even if it resizes? I want to point out interesting things in a chart I have. -- RealRaven ------------------------------------------------------------------------ RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058 View this thread: http://www.excelforum.com/showthread...hreadid=567787 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding pinned arrows to a chart
I've tried that. It sure becomes a nice arrow. And I can get it to scale with the entire chart, but not with the axis. If my x-axis is from 0 to 10 and I draw an arrow right at x=5. Then scale my x-axis to be 0 to 20, the arrow will point at 10, not 5 as I want. -- RealRaven ------------------------------------------------------------------------ RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058 View this thread: http://www.excelforum.com/showthread...hreadid=567787 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding pinned arrows to a chart
Drawn shapes are not pinned to specific chart positions, and sometimes move
on their own even if the data or axes don't change. However, you can use drawn shapes as custom data markers, and they will move with the axis scales: http://PeltierTech.com/Excel/Charts/PointAtPoints.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RealRaven" wrote in message ... I've tried that. It sure becomes a nice arrow. And I can get it to scale with the entire chart, but not with the axis. If my x-axis is from 0 to 10 and I draw an arrow right at x=5. Then scale my x-axis to be 0 to 20, the arrow will point at 10, not 5 as I want. -- RealRaven |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Adding pinned arrows to a chart
On Thu, 3 Aug 2006, in microsoft.public.excel.charting,
RealRaven said: I've tried that. It sure becomes a nice arrow. And I can get it to scale with the entire chart, but not with the axis. If my x-axis is from 0 to 10 and I draw an arrow right at x=5. Then scale my x-axis to be 0 to 20, the arrow will point at 10, not 5 as I want. Bernard's suggestion won't work for you because, as you said, you want the arrow to point at a pair of coordinates on the chart, even if you change the chart size. Jon Peltier has the answer you're looking for, with his article "Use an Arrow to Indicate Special Points": http://peltiertech.com/Excel/Charts/PointAtPoints.html -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a horizontal line to a stock chart | Charts and Charting in Excel | |||
| Adding an average line to a bar chart | Excel Discussion (Misc queries) | |||
| Adding series, this time with a 2 axes line chart | Charts and Charting in Excel | |||
| adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Linear Mode
