Change hover label data on Scatter plot chart

123excel

New Member
Joined
Jan 18, 2017
Messages
34
Hi, I have 8 scattered plot charts, all containing more than 300 dots.. This means that I cant use ordinary labels, because it destroys all visibility of the chart.

So I need to hover the dots to see the label data. This works good but I cant manage to get the names of the items on the hovering label. When I choose the data I can pick X data, Y data and series name. But when I choose a range for "series name" it shows me all names at ones.. How can I make the hovering label to show only the name for the specific item?

My plot chart is in sheet "analysis"

My data table is in sheet "1-1.5" and the axis is:
X: K1:K3000
Y: F1:F3000
Name range: A1:A3000

Am I missing something simple? I have been spending hours on this..
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,099,543
Messages
5,469,337
Members
406,647
Latest member
ssinovec

This Week's Hot Topics

Top