Custom Hover bubble in a XY Scatter plot

Hello all,

The data I have is simply 3 columns. Column A contains Stock Tickers, B contains the X values and C contains the Y values.

The objective is to plot the data points with only the tickers showing and when the mouse hovers over the x and y values are displayed.

I though this would be simple but as I keep looking and working on it seems to be much more complex than I thought but perhaps I am simply overlooking something, hopefully all you geniuses on here can help.

I have attached a sheet that will show it the process I went through, as I explain below.

I had originally thought I could select the 3 columns, graph it and the tickers would be assigned to each data point but instead I get a scatter plot that plots two point for each ticker with the row number being the x value (Sheet 1).

So the next thing I did was get a macro that would assign the labels in col A to the data points. I then formatted the chart to have no markers and move the labels to center(this is not by macro, only putting label points in is). This can be seen on Sheet 2. If you would like to replicate the work, just delete the labels on the graph and hit the macro button. This looks like the way I want it except for that fact that when you hover over a Ticker the x,y values are not shown anymore because the mouse hovers over the label and not the actual data point. (Sheet 2)

My third idea was to add each data point to the chart as its own separate series (by macro) and in this way I can just use the "series name" option for the data label. I run into the same problem though of having to hover over the label and not having the x,y value displayed. I left a couple different examples on the chart in Sheet 3.

The reason I only want the tickers and not the marker is to make the points are easily recognized as there will be about 75 points so it helps cut down on clutter.

So after going through these options I was thinking that perhaps the only option I have is to use the mouseover function to display the xy values when rolling over the label.

I would prefer not to have to do it this way so if any of you have a different solution I would love it and if not I would still be appreciative of a mouseover solution.

Much thanks,

Tony