Thread: XY chart with labeled dots

Hi, I have the following table (just an example):

Name X Y
dot_1 1 5
2_dot 3 8
odot 7 4

I use standard XY chart and select numeric area. When pointing to the dot with mouse, I see "Series 1 point 1 (1,5)", "Series 1 point 3 (3,8)" and "Series 1 point 7 (7,4)".

I want graph to show something like the following: "Series 1 point "dot_1" (1,5)", "Series 1 point "2_dot" (3,8)" and "Series 1 point "odot" (7,4)". Is that possible with Excel?

Splitting points to separate series is not a sloution because there're more than 1000 points on the graph.

Thanks for your help.

Originally Posted by Andy Pope

You can not change the contents of the built-in tooltip.
This addin will allow you to create a custom tooltip.
http://tushar-mehta.com/excel/softwa...bel/index.html

Thank you Andy. Installed it and see it is not what I am looking for. It displays name next to the point, if points density is high label becomes undeadable.

What I wanted is to have this kind of "pop-up" (tooltip) excel information.

Originally Posted by Andy Pope

You will have to write your own chart event code to capture chart elements under the cursor and then display this information via a textbox.

For more information see Jon's article.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

He also has a couple of download files under Events
http://peltiertech.com/Excel/Charts/ChartIndex.html#E

Thanks again. Seems Excel is not a right tool for drawing graphs in my case. My graph contains several tenths thousands of points, and I expect redrawing through script on each mouse move will be awful.