I am currently having a problem creating scatter plots where I can only select X or Y data. When I select say for example X data the selection box becomes unclickable except for OK, when clicked it plots the X value/s. If I go back in and edit the data series I can then select the Y data, which causes the previously selected X data to disappear in the selection box, as well as making everything unclickable except for OK however this does create the correct chart. I have attached two images of the process, the first one is the selection of X and second is the selection of Y which shows the correct plot. I have also attached the work sheet although this happens with every sheet I create






X_Y problem.xlsx
X only.jpg
Y only.png