pop-up/comment of text in chart

[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

 

[AlfD]

Hi!

Have a look at Jon Peltier's website, www.peltiertech.com.

Look at what he has to offer.
If it is what you need, try it and come back if you need help o
implementation.

Al

 

[Jon Peltier]

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/
_______