 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008Comments in Charts
Two years ago Mike P. from KC asked: "Is it possible to have a data cell's comment (which shows up on mouse-over of the red triangle in the upper right of the cell) also show up on mouse-over of the data point on a chart that takes a data point or points from a "commented on" cell(s)? If so, how can you do it? " The only reply was from Jon Peltier: "This isn't a native Excel capability, but it's an interesting idea, and one that could be accomplished using VBA." Does anyone know if this has been done yet? If so how could I get that macro? It remains an interesting idea. I've had no further interest in it until now. I haven't addressed this problem yet, because it's a multiple-part routine. It requires chart events to detect a mouseover on the chart, it requires parsing of the chart data to determine which cell contains the data point's value, and it requires reading and displaying of the comment. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Two years ago Mike P. from KC asked: > "Is it possible to have a data cell's comment (which shows up on [quoted text clipped - 12 lines] > Does anyone know if this has been done yet? If so how could I get that > macro? AFter more digging I found that actually Jon, you did supply an answer of sorts on Oct of 2006 : "Marie - Excel doesn't have this capability built-in, but it is flexible enough that clever programmers can provide similar functionality. In this case, the clever programmer is my colleague Tushar Mehta. On his web site (http://tushar-mehta.com) is a utility called Chart Hover Labels, which will do what you need. - Jon" I am going to try it out and see how it works. Problem is it seems rather "all or none". I would like to have a data label and then show more detail on rollover, but I think Hover Chart Label just wants to ONLY show when you hover. > It remains an interesting idea. I've had no further interest in it until > now. [quoted text clipped - 27 lines] > > Does anyone know if this has been done yet? If so how could I get that > > macro? Does not appear to be working corrrectly. I just get the labels displayed permenatly or get a Run-Time error message. Maybe this is due to "limited testing" with Excel versions 97, 2000 and 2002. I have 2002. So no answer to question yet. > AFter more digging I found that actually Jon, you did supply an answer of > sorts on Oct of 2006 : "Marie - [quoted text clipped - 43 lines] > > > Does anyone know if this has been done yet? If so how could I get that > > > macro? Hover Chart Label operates independently of any data labels. Apply the data labels you want, using one of these add-ins if the built-in options don't show what you want: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Then use Tushar's utility for the labels that show when you mouse over the points. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > AFter more digging I found that actually Jon, you did supply an answer of > sorts on Oct of 2006 : "Marie - [quoted text clipped - 48 lines] >> > Does anyone know if this has been done yet? If so how could I get that >> > macro? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.