Hovering over columns in a column chart to make selected textboxes visible

[piggeh]

hello~~

i'm trying to create a dashboard for a school project, and i'm trying to make different details in various textboxes appear when my mouse is hovering over the columns (like the picture below), but i'm unable to do so..


ticket.png


this is what im trying to achieve (a picture i edited using paint).

however, so far, i can only get the basic graph out so far as shown below. how do i do the hovering so that it is compatible with microsoft excel 2003 and 2007?

i name ranged the textboxes as textbox1, textbox2, etc. respectively.

i thought of using textbox to display the details i need, and to make the textbox visible when my mouse is hovering over the column but im not able to get it work..

textbox.png

May i know if it is possible to do this hovering function out in excel and how do i do it?

Please help me! Thank you very much~~!