Scatter Graph servies value display (VB)

[pauldaddyadams]

Hi,

On my orignal post

I needed the label name to appear when I hovered over a point on a scatter graph which was solved - this displayed the customer name or product name depending on what sheet was in use.

Is there any way the code below can be adapted to show Profit (colum E) and Sales (column D), as well as the label name?

e.g. when I hoover over it will say: Customer ABC (already working above), Profit £x, Sales £x

This is the code:

Please Login or Register  to view this content.

I have uploaded an example file

Paul

[pauldaddyadams]

Anyone?

[JosephP]

Please Login or Register  to view this content.

[pauldaddyadams]

Hi Joseph

Thanks for the above code.

This code works 100% on my "products" sheet but I also require it on the "customer" sheet - is there any way I can have it working on both?

When I hoover over a scatter graph point I get the customer name, profit and sales from the code you supplied but I also get the default grey box appear - can i disable this do you know?

[JosephP]

Please Login or Register  to view this content.

for the built-in tooltips you have to turn those off in Excel Options I believe

[pauldaddyadams]

Superb!!! I had forgotten that the code above was placed on both worksheets

Thanks Joseph