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