I have a scatter chart with dots that represents information in a spreadsheet. I would like to place my cursor on a "particular dot" and it would show the contents of a "particular cell" in the spreadsheet. When I move my cursor away from the dot, the contents would disappear. I do not want to add the contents as permanent labels because the chart would become very cluttered with many dots.
What information are you intending to display? By default, Excel already pops up information about the point in question (name of the series and the x and y value).
That is correct the name of the series does pop up. If however, I have 100 points to plot, I believe each would have to have a separate series name. If so, that would be very cumbersome.
Yes, it appears to be a solution, if I understand it, but very involved as I mentioned. I am trying to determine if there is something a little more simple.
No there isn't anything simpler. This could be programmed into something that is relatively simple to use though. But it would require either an add-in that all of your users must install, or VBA code that needs to go into any workbook that makes use of this feature.
Thank you for the reply. It appears there are two solutions. Not being an expect in excel, how would I go about getting either approach? And which approach would be best in your opinion? Thanks
