For some reason when I'm trying to plot data that have very small ranges, the dots in scatter plot do not line up correctly. for example a dot with x=4, y=4, plots on x=~4.2 and y = ~3.8 Once I introduced more variability (greater range of data), the scatter plot looks accurate.
I checked to make sure all values are numbers using ISNUMBER function.
Also originally Excel created y axis scale that looked like 0, 0, 1, 1, 2, 2, 3, 3...etc instead of 0, 1, 2, 3..etc
I attached my spreadsheet. Any help would be greatly appreciated.
thank you in advance for your time and assistance!
Lisa
Bookmarks