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..
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..
