In the Format Data Labels window that appears on the right of the screen, uncheck the box next to Y Value and check the box next to Value From Cells. Then click Data Labels, then click More Options.
Xy scatter plot excel plus#
Who knows, if you are interested enough, we might go on to recreate my program in VB, with its superior graphics ability. Next, click anywhere on the chart until a green plus (+) sign appears in the top right corner. 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. Heres how: Click on the highlighted data point to select it. 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. To let your users know which exactly data point is highlighted in your scatter chart, you can add a label to it. 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. 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.
Click OK a couple times to return to Excel. 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.
0 kommentar(er)
