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 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.
Can this be done?
Thank you
- 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?
HansVogelaar I was thinking about the exact same solution 🙂
