#XY SCATTER PLOT EXCEL HOW TO#

If one of the readers is really and truely interested in the topic, please send me a PM, and I will gladly dig up my old program and discuss it with you, step by step, explaining the reasoning that goes on behind finding a 'best-fit' curve for a given set of points. I could, and would, if I had sufficient motivation, redo my program in VB, but, I am not there yet, as I have other interests.

Right click this blank chart > Select Date Source > click Add > Enter the Series Name, such as Label A, select the data range for X values and Y values. Go to Insert > Choose one Scatter Graphic in Charts group, then we will get a blank chart. However, when I 'upgraded' to Windows Xp from Windows 98, the QuickBASIC plotting ability was gone ((I believe ALL DOS-derived programs lost that ability for the SCREEEN command in BASIC)! Sadly, Micorsoft no longer supports many of the old DOS-based 'goodies', and, we must upgrade, just to keep up. Apart Paste Special, we could also use Select Date Source. One then had the option of choosing a different degree, with the immediate re-calculation of a new best-fit curve equation, R^2 value, plotted curve and all points clearly visible. Open the Program and File Launch Excel and open the spreadsheet with the data to transform into an X-Y scatter plot diagram.

For each series, enter data values with space delimiter, label, color and trendline type.

#XY SCATTER PLOT EXCEL HOW TO#

Click OK a couple times to return to Excel. How to create a scatter plot Enter the title of the graph. Add a new series, Edit this series, select the ranges with the series name, X Values, and Y Values. Insert an XY Scatter chart, which will be blank, because no data was selected. I wrote a program in QuickBASIC 4.5 which allowed one to enter a series of x, y values, then allowed selecting the degree of the equation desired, up to the 'maximum degree = number of points - 1', and my program would then return a 'best fit' curve equation and the R^2 value, together with the plot of the curve and all the x, y points clearly visible. Select a blank cell a few rows or columns away from the pivot table.

Xy scatter plot excel