BACKGROUND
I'm trying to attach labels to data points in my xy scatter chart (see sheet: 'Graph - per role'). The label-data (see sheet: 'Form') are to contain names from column C; the X and Y values are in respectively column D and E.
Whilst XLS doesn't provide the possibility to add labels to data points in a XY scatter chart, I've searched for solutions and found a macro (see sheet 'Macro') and included it. So far, so good.
LIMITED and ONLY PARTLY CORRECT SOLUTION
Whilst the macro does attach (name) labels to the data points, it does not provide the correct (name) labels. This is likely caused because I do not use all names from column C for the scatter graph, but make a selection of names through a filter in column B.
ISSUE
- The graph does present the correct (x&y) data points of filtered column D and E.
- But, the filtered data points do not have the correct (name) labels attached.
- Instead of attaching the 9 selected/filtered names from the list of 100 names in column C, the macro picks the 9 names from the top of column C, ignoring the filter selection made in column B.
QUESTION
Since I'm totally inexperienced with writing macro's, let alone adjusting them, can anyone help me to fix the macro?
Help is greatly appreciated.
Bookmarks