Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ControlTip Text for Points in Graphs

Status
Not open for further replies.

Edski

Programmer
Aug 6, 2003
430
TH
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).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top