LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.charting
Dave
 
Posts: n/a
Default Pin a callout data point

Thank you Jon - that got it.

Went with the single point series. Worked great, looks good.
Really appreciate your suggestions.

Thx again,
Dave


"Jon Peltier" wrote in message
...
Dave -

You cannot lock an autoshape to a particular point in a chart. You can use
a data label on the point, with a custom label, but if you insert or
remove points before this one (i.e., change the starting point of the
series), the label will also not stay attached to the right point. You can
format a single point differently to help draw attention to it (a
different marker shape or color, or even a custom shape), but again this
moves if you insert or remove points.

You could add another series, with just a single point, and format this
one with the label or custom marker you want, and it won't have the same
issue as above if the number of points changes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Dave" wrote in message
...
Posted this on 'Excel' by mistake -

I have a callout box on a rather complicated graph. It really only has
value if it always points to the data point to which it refers. If I move
the end of the pointer over the data point, it looks exactly as I want it
to. However of I move the graph on the screen, look at it in Print
Preview,
or worse, print it, the data point is liable to be anywhere.

Is there a way to pin the pointer to a particular data point so it will
stay
there??

Thx
Dave







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Chart Data Point Highlighting rvExcelNewTip Charts and Charting in Excel 6 January 8th 06 05:21 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Height (in points) of data point in chart above x-axis Scott P Charts and Charting in Excel 5 November 13th 05 01:56 AM
Data Point labeling Russell-stanely Charts and Charting in Excel 1 September 16th 05 08:15 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"