Hi guys,
I'm creating an application that involves clicking on specific points on a scatter plot chart in Excel to bring up a dialog box. The problem is that, in certain parts of the chart, data labels are over the points, so I select the label instead of the point when I click.
I know I could write the program to automatically select the correct point when a data label is clicked, but if I am to apply this program to different charts this isn't ideal.
Does anybody know how, in Excel or VBA, to send data labels to the back of a chart?
Andrew
I'm creating an application that involves clicking on specific points on a scatter plot chart in Excel to bring up a dialog box. The problem is that, in certain parts of the chart, data labels are over the points, so I select the label instead of the point when I click.
I know I could write the program to automatically select the correct point when a data label is clicked, but if I am to apply this program to different charts this isn't ideal.
Does anybody know how, in Excel or VBA, to send data labels to the back of a chart?
Andrew
