I think I know the answer to this question (not possible) but just want confirmation.
The ControlTipText Property is only available for controls on a form, such as a TextBox, CheckBox, etc.... and it can be edited using VBA.
But what about charts? When you position the mouse over a single point on a scatterplot or other graph type with markers, for example, you get what looks like a ControlTip, in the same colour as the ControlTipText thingy on a Form. Same thing happens if you position the mouse over any other object in the chart, such as the title, legend, axis, etc...
Question is: Can this 'Tip' thingy be edited using VBA? If so, what is it called?
The reason I asked is because on a scatterplot, the tip is nice but it repeats the x-value (Eg, Series "y" Point "2" (2,5)). the "2" here is redundant and I'd like to replace it with something more informative (or delete it all together).
The ControlTipText Property is only available for controls on a form, such as a TextBox, CheckBox, etc.... and it can be edited using VBA.
But what about charts? When you position the mouse over a single point on a scatterplot or other graph type with markers, for example, you get what looks like a ControlTip, in the same colour as the ControlTipText thingy on a Form. Same thing happens if you position the mouse over any other object in the chart, such as the title, legend, axis, etc...
Question is: Can this 'Tip' thingy be edited using VBA? If so, what is it called?
The reason I asked is because on a scatterplot, the tip is nice but it repeats the x-value (Eg, Series "y" Point "2" (2,5)). the "2" here is redundant and I'd like to replace it with something more informative (or delete it all together).