pop-up/comment of text in chart

  • Thread starter Thread starter acl
  • Start date Start date
A

acl

Hi

I am basically brand new to VBA and excel macros...so please keep tha
in mind. If the solution lies in either of those, if you would be kin
enough to show me that would be greatly appreciated.

Is it possible to create a pop-up of some sort when a bar is clicked
so it displays text from different cells combined. Like under column
on the spreadsheet I have values in A1, A2, A4, A5, representin
titles. Then there is another column corresponding to each cell, i
maybe E1, E2, E4, and E5, outlining a description. The popup would the
pop up and display the title followed by a : and then the description
in paragraph format. So for instance the popup would display:
------------
|title(A1): description(E1)
|title2(A2): description(E2)
--------------

etc.
If a popup is not viable then a display mechanism like a comment woul
also work, although I realize the usual comment can only display 18
chars.
I hope it is clear what I am trying to do. Please take note that I nee
each bar in the bar graph to display certain cells.



Thanks in advance
ac
 
If you want something which is ready out of the box, look at Tushar
Mehta's Chart Hover Label add-in (http://tushar-mehta.com).

If you want some more basic examples, check out these two, one for chart
sheets, one for any sheet. Obviously, you can program it to pop up
whatever message you want.

http://peltiertech.com/Excel/Zips/GetXYonaChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

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