Forum Discussion
Dot Displaying in a Scatter Chart
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 sprea...
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.
- Did you try the solution HansVogelaar pointed to?
- 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.