Hi there.
I have put a file on the following link: https://www.dropbox.com/s/icu4rtgoy6oy3bw/Scatter Charts problem.xlsm?dl=0
I hope this is ok, as we are not able to post attachments.
I am having some problems with some labels appearing on the scatter charts. If you look at the file on the link you will see three tabs. One tab labelled correct and one labelled incorrect. You will be able to click on the scatter plots on the correct tab and labels pop up. This is correct and shows the VBA that I have is working.
This does not appear to work on the second tab though and I think it is because there are two charts instead of 1 and it is trying to apply the VBA to the first chart.
Does anyone know how I can alter this so it works on the scatter chart? I know the easy answer is to make the scatter chart the first chart on the page but this is an example from a more complicated file and this woulf not be possible.
Thank you very much in advance for any help/guidance.
I have put a file on the following link: https://www.dropbox.com/s/icu4rtgoy6oy3bw/Scatter Charts problem.xlsm?dl=0
I hope this is ok, as we are not able to post attachments.
I am having some problems with some labels appearing on the scatter charts. If you look at the file on the link you will see three tabs. One tab labelled correct and one labelled incorrect. You will be able to click on the scatter plots on the correct tab and labels pop up. This is correct and shows the VBA that I have is working.
This does not appear to work on the second tab though and I think it is because there are two charts instead of 1 and it is trying to apply the VBA to the first chart.
Does anyone know how I can alter this so it works on the scatter chart? I know the easy answer is to make the scatter chart the first chart on the page but this is an example from a more complicated file and this woulf not be possible.
Thank you very much in advance for any help/guidance.
