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. I am just creating a bar graph with some values. Is it possible to display a comment or text from a cell if I mouse over or click one of the bars? I was basically looking for a popup like a comment.
More importantly, 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:
If a popup is not viable then a display mechanism like a comment would also work.
I hope it is clear what I am trying to do. Please take notice that I need each bar to display text in certain cells, each varying from bar to bar.
Thanks in advance