Add Data Labels to Dynamic Scatter Plot

Hi all,

Thanks for reading. I am very new to VBA but am hoping with some help I can pull this off.

My table has 4 columns (Category, Label, X, and Y). I am creating a scatter plot (X and Y) and using a macro to assign data labels (Label) to the points. However, when I filter (on Category) the labels are static and do not change with the data in the table. The labels do not correlate to the data point they are placed on. If I have a list of 10 items and filter it down to 3, the first 3 labels (labels in rows 1-3) will be assigned to those points even if they were items 8-10.

I am looking for a solution to have the labels stay with the points as the data is filtered. Any tips would be appreciated.

I hope this makes sense and that someone can help me solve this. The code is below, taken from a tutorial.

Please Login or Register  to view this content.

Thank you so much Andy! This works like a charm.

Great explanation in the post. I actually had read that earlier but couldn't figure out how to apply within VBA.