Here are some problems that our users have asked and received explanations on
My XY scatter plot is not displaying correct X values
Solved by A. A. in 24 mins
Trying to build a xy scatter chart in excel
Solved by I. J. in 18 mins
I cannot get any data points to plot on the negative x axis. For instance, my lowest x value is -357 but was automatically given the x value of 1 when the scatter plot was created. Is there a way for me to extend the xy scatter plot so it will show my x values properly?
Solved by I. A. in 12 mins
I have a data set that I need a linear XY plot on and use the y intercept. When I use the "Intercept" function, I get a different result than if I plot the data and ask for the equation of the best fit line..
Solved by D. B. in 17 mins
I'm trying to plot on an XY scatter. I'm pulling data from cells that contain: =IF(OR(ISBLANK(C9),ISBLANK(D9)),"",D9/C9)
This doesn't read as a numeric value and therefor my graph is sequential instead of using the values