I have an XY Scatter chart in Excel with 400+ points in four data series. I would like to add text to each data point by modifying the Chart tips (which defaults to showing the series name and the point x,y value). Is this possible?
Things I've tried so far:
- There is a tool here which adds permanent text labels. This is great for selecting the text I want, but if the points are close together (as in my case) you get a mass of illegible black letters.
- There is also a tool which adds a hover command to the text labels which makes them large when you mouse over them but size 1 pt text when you do not. This is a step in the right direction but breaks down when you have multiple charts and does not look as professional as I would like.