I want to plot location of water wells using its X and Y coordinates in Excel. I am doing this in Excel such that every time I have a change in X and Y coordinates, I do not need to go back to the mapping software to re-generate new maps. So, I can use bubble maps if I want the size of the wells to be included or if I am not interested in the size of the wells and am only interested with the locations, I can use scatter plot.
My problem:
I used both bubble and scatter plots and for some reasons, all my wells have y-values of zero even though the column of data for the Y-axis (the y-coordinate) has real non-zero values. So, the points ended up along the Y = zero with various locations along the x-axis. The x-axis is correct, but the y-axis isn’t picking up the actual non-zero Y coordinates. I have attached my spreadsheet here to see if anyone here can help find out what is causing this and what the fix is.
My problem:
I used both bubble and scatter plots and for some reasons, all my wells have y-values of zero even though the column of data for the Y-axis (the y-coordinate) has real non-zero values. So, the points ended up along the Y = zero with various locations along the x-axis. The x-axis is correct, but the y-axis isn’t picking up the actual non-zero Y coordinates. I have attached my spreadsheet here to see if anyone here can help find out what is causing this and what the fix is.