Custom Chart Tooltips VBA

[lyla22]

Hi,

I have a line chart (multiple series) in which I am trying to display custom tooltips on the data points. The source for these custom tooltips are the Notes columns in the first worksheet. The code (which I've copied from an internet site) is working to some degree but I'm not sure how to modify it to pick up the notes column as the content for the tooltips. Also, the example I took this from only had one line whereas I will have 5 when the chart is complete.

Has anyone got any ideas? Is this even possible!?

Any help would be greatly appreciated!

Lyla

[Andy Pope]

Please Login or Register  to view this content.

[lyla22]

Thanks so much Andy, that's brilliant!

Now, I have another question. As an alternative to the approach above, is it possible to click/double-click on a chart data point and have it bring you to the cell that data point is taking it's value from? Then, the note can be viewed easily as it's directly beside the cell in question. I'm just wary that this chart is going to grow over time and having the hover labels might become tedious so it would be nice to have another way of linking to the notes.

Thanks,
Lyla

[Andy Pope]

The user will have to select the series and then double click the data point

Please Login or Register  to view this content.

To size the hover label

Please Login or Register  to view this content.

[lyla22]

Hi Andy,

The double-click doesn't seem to be working consistently. It is moving to the correct sheet but not selecting the correct cells. A double-click might bring you to the correct cell, then if you go back and double-click another point, it might bring you right to the end of the sheet or a few cells away from the correct one, no consistent pattern that I can see?

Thanks again for your help.

[Andy Pope]

try this variation

Please Login or Register  to view this content.

[lyla22]

That works perfectly, Andy.

Thank you, much appreciated!