pop-up/comment of text in chart

Hi

I am basically brand new to VBA and excel macros...so please keep that
in mind. If the solution lies in either of those, if you would be kind
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 A
on the spreadsheet I have values in A1, A2, A4, A5, representing
titles. Then there is another column corresponding to each cell, in
maybe E1, E2, E4, and E5, outlining a description. The popup would then
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 would
also work, although I realize the usual comment can only display 180
chars.
I hope it is clear what I am trying to do. Please take note that I need
each bar in the bar graph to display certain cells.



Thanks in advance
acl


---
Message posted from http://www.ExcelForum.com/

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 on
implementation.

Alf


---
Message posted from http://www.ExcelForum.com/

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/Ge...ChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

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

AlfD wrote:

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 on
implementation.

Alf


---
Message posted from http://www.ExcelForum.com/