Thread: Adding Value to Screen Tip When Hovering Over Chart Values

I have a table with Column A = Person’s Name, Column B = Height in Inches, and Column C = Weight in Pounds. I’m able to create a scatter plot where Column B is the X axis and Column C is the Y axis. When I hover the mouse over a data point, the screen tip correctly shows the Column B and Column C values.

My problem is that I cannot determine how (either through the Chart Wizard or VBA code) to add Column A as a series so that the person’s name is also shown (along with the Column B and Column C values) when I hover the mouse over a point.

If someone can offer guidance, I would be really appreciative.

Thanks.

Thanks - but I wasn't clear. I want the Column A person's name to appear in the popup screen tip (or whatever it's called) only when the mouse is hovering over the data point - not as a permanent part of the label.

Thanks very much for your time.

The values display perfectly on your chart - just as I want them on mine. But I think the difference (and why it may not be possible with mine) is that I use actual Column B values for the X axis values, while I believe you use some sort of index number. So I don't think I can change my series characteristics to use Column A values for the X asis as you have done.

The basic problem, I think, is that in my case the X values are not discrete, but continuous, and so the series they "come from" must be displayed by a scatter plot, not line. That being the case, I don't think I can get your solution to work. Thanks again for all your time - I really do appreciate it.

Hi,

I hope the attached picture clarifies more than confuses, so let me explain.

First, my original posting used an example which I had hoped would reflect my real life situation, but in a way that would be easier for any reader to understand.

The real situation is a worksheet that is built via VBA based on a subtotaling and copying of four columns of data from another sheet, and displaying detail level 2.

As you see, column B is used (in 000s) as X values. It’s continuous in nature, not discrete, so the charts are scatter plots rather than line.

Column C is plotted against the secondary Y axis, with only the trend line being shown (no markers), so it can be ignored for this discussion.

Column D is plotted using the primary Y axis, with both a trend line and markers. There are only two jobs (column A), so only two markers appear in this example (at the very ends of the blue trend line).

What I want is for a screen tip (or whatever it’s called) to pop up when the mouse is hovering over a blue marker so that the job title is shown in addition to the Column D value. If the tip also shows the X value (Column B) that would be great – but I would give that up in return for displaying Column A.

I hope this makes sense.

Thanks very much for trying to help. I'm glad, in a sense, that there might not be an obvious answer that I just didn't see. It could be that it's just not possible. Thanks again.