Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
I have a scatter plot chart that plots eight different coordinate points and
it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
Choose minimum and maximum X values for your new line & put them in one
column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
I'm not sure I completely understand.
I want my line to run from x = 0 to x = 4000. Therefore, my corresponding y min and max would be: min: y = 0.35592(0) + 0.1988939 = 0.1988939 max: y = 0.35592(4000) + 0.1988939 = 1423.8788939 Now, I did as you said and put these four values into my spreadsheet. I have the x min in cell E1, the y min in cell F1, the x max in cell E2, and the y max in cell F2. So, what exactly do I put under "X Values: " and "Y Values: " when I add a new Series? "David Biddulph" wrote: Choose minimum and maximum X values for your new line & put them in one column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
Reference to your column with the 0 and 4000 cells (E1:E2) goes in the "X
values", and the reference to the column with the two Y values (F1:F2) goes in the "Y values" series. If you just click in the relevant series box for the new series, then go to the sheet with the data and select the relevant cells, it will put the cell references in automatically. -- David Biddulph "BigDaddyCool" wrote in message ... I'm not sure I completely understand. I want my line to run from x = 0 to x = 4000. Therefore, my corresponding y min and max would be: min: y = 0.35592(0) + 0.1988939 = 0.1988939 max: y = 0.35592(4000) + 0.1988939 = 1423.8788939 Now, I did as you said and put these four values into my spreadsheet. I have the x min in cell E1, the y min in cell F1, the x max in cell E2, and the y max in cell F2. So, what exactly do I put under "X Values: " and "Y Values: " when I add a new Series? "David Biddulph" wrote: Choose minimum and maximum X values for your new line & put them in one column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
I did that, and the problem is it just interprets it as two more plot points
rather than the endpoints of a continuous line graph. "David Biddulph" wrote: Reference to your column with the 0 and 4000 cells (E1:E2) goes in the "X values", and the reference to the column with the two Y values (F1:F2) goes in the "Y values" series. If you just click in the relevant series box for the new series, then go to the sheet with the data and select the relevant cells, it will put the cell references in automatically. -- David Biddulph "BigDaddyCool" wrote in message ... I'm not sure I completely understand. I want my line to run from x = 0 to x = 4000. Therefore, my corresponding y min and max would be: min: y = 0.35592(0) + 0.1988939 = 0.1988939 max: y = 0.35592(4000) + 0.1988939 = 1423.8788939 Now, I did as you said and put these four values into my spreadsheet. I have the x min in cell E1, the y min in cell F1, the x max in cell E2, and the y max in cell F2. So, what exactly do I put under "X Values: " and "Y Values: " when I add a new Series? "David Biddulph" wrote: Choose minimum and maximum X values for your new line & put them in one column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
You need to add a new series, rather than just adding to the existing
series. You may well get away with copying the 4 cells (E1:F2), then going to the graph, & using Edit/ Paste Special, selecting new series, data in columns, etc. -- David Biddulph "BigDaddyCool" wrote in message ... I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. "David Biddulph" wrote: Reference to your column with the 0 and 4000 cells (E1:E2) goes in the "X values", and the reference to the column with the two Y values (F1:F2) goes in the "Y values" series. If you just click in the relevant series box for the new series, then go to the sheet with the data and select the relevant cells, it will put the cell references in automatically. -- David Biddulph "BigDaddyCool" wrote in message ... I'm not sure I completely understand. I want my line to run from x = 0 to x = 4000. Therefore, my corresponding y min and max would be: min: y = 0.35592(0) + 0.1988939 = 0.1988939 max: y = 0.35592(4000) + 0.1988939 = 1423.8788939 Now, I did as you said and put these four values into my spreadsheet. I have the x min in cell E1, the y min in cell F1, the x max in cell E2, and the y max in cell F2. So, what exactly do I put under "X Values: " and "Y Values: " when I add a new Series? "David Biddulph" wrote: Choose minimum and maximum X values for your new line & put them in one column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
I already did add a new series.
I have two series: one for the plotted points, one for the line graph. Why is it interpreting the four cells as plot points and what can I do about it? "David Biddulph" wrote: You need to add a new series, rather than just adding to the existing series. You may well get away with copying the 4 cells (E1:F2), then going to the graph, & using Edit/ Paste Special, selecting new series, data in columns, etc. -- David Biddulph "BigDaddyCool" wrote in message ... I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. "David Biddulph" wrote: Reference to your column with the 0 and 4000 cells (E1:E2) goes in the "X values", and the reference to the column with the two Y values (F1:F2) goes in the "Y values" series. If you just click in the relevant series box for the new series, then go to the sheet with the data and select the relevant cells, it will put the cell references in automatically. -- David Biddulph "BigDaddyCool" wrote in message ... I'm not sure I completely understand. I want my line to run from x = 0 to x = 4000. Therefore, my corresponding y min and max would be: min: y = 0.35592(0) + 0.1988939 = 0.1988939 max: y = 0.35592(4000) + 0.1988939 = 1423.8788939 Now, I did as you said and put these four values into my spreadsheet. I have the x min in cell E1, the y min in cell F1, the x max in cell E2, and the y max in cell F2. So, what exactly do I put under "X Values: " and "Y Values: " when I add a new Series? "David Biddulph" wrote: Choose minimum and maximum X values for your new line & put them in one column. Calculate corresponding Y values from your equation and put them in the next column. These then form the X and Y series to add as your new series to the chart. -- David Biddulph "BigDaddyCool" wrote in message ... I have a scatter plot chart that plots eight different coordinate points and it looks really awesome. I also have done some calculations to my data and have a linear equation of y = 0.35592x + 0.1988939. I want to plot this linear equation over the same chart as my scatter plot to show that the line and the scatter plots are very closely related. How can I do this? I assume you right-click on the chart and click on "Source Data" and add another Series, but then what? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
"BigDaddyCool" wrote I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. Go to Format.. Selected Data Series.. and click the radio button in the Patterns:Line dialogue from "None" to "Automatic" or "Custom". If you want, you can also switch off the points by clicking the Marker radio button from "Automatic" to "None". Now you have a line and points, or a line and no points. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
Yay! You rock! Thank you!
I guess this little trick couldn't work with any curved graphs, though (because all we're doing is connectiong two already calculated endpoints with a line). I mean, there isn't any real "computing" going on, is there? :( BigDaddyCool "Del Cotter" wrote: "BigDaddyCool" wrote I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. Go to Format.. Selected Data Series.. and click the radio button in the Patterns:Line dialogue from "None" to "Automatic" or "Custom". If you want, you can also switch off the points by clicking the Marker radio button from "Automatic" to "None". Now you have a line and points, or a line and no points. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
If you've got a curved line, such as a quadratic rather than your linear
expression, then you'd need to include more than two points. Instead of just using X values of 0 and 4000, you could interpolate and have values 0, 200, 400, etc. for example. Then use your expression for Y as a function of X to let Excel calculate the Y values in the second column, and plot the graph as you've just done. You can either let Excel join the points with short straight lines like the one line you've just drawn between your two points, or (if the curve is reasonably well-behaved) you can let Excel put in a curve through the points. [You've seen the different sub-types within the XY chart option.] -- David Biddulph "BigDaddyCool" wrote in message ... Yay! You rock! Thank you! I guess this little trick couldn't work with any curved graphs, though (because all we're doing is connectiong two already calculated endpoints with a line). I mean, there isn't any real "computing" going on, is there? :( BigDaddyCool "Del Cotter" wrote: "BigDaddyCool" wrote I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. Go to Format.. Selected Data Series.. and click the radio button in the Patterns:Line dialogue from "None" to "Automatic" or "Custom". If you want, you can also switch off the points by clicking the Marker radio button from "Automatic" to "None". Now you have a line and points, or a line and no points. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding a linear equation to my groovy scatter plot.
You can approximate a curve by stringing together a lot of short segments.
In other words, instead of two endpoints based on two X values and the coefficients, use enough X values so that the curve looks smooth, and calculate the Y values in the next column in the same way. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "BigDaddyCool" wrote in message ... Yay! You rock! Thank you! I guess this little trick couldn't work with any curved graphs, though (because all we're doing is connectiong two already calculated endpoints with a line). I mean, there isn't any real "computing" going on, is there? :( BigDaddyCool "Del Cotter" wrote: "BigDaddyCool" wrote I did that, and the problem is it just interprets it as two more plot points rather than the endpoints of a continuous line graph. Go to Format.. Selected Data Series.. and click the radio button in the Patterns:Line dialogue from "None" to "Automatic" or "Custom". If you want, you can also switch off the points by clicking the Marker radio button from "Automatic" to "None". Now you have a line and points, or a line and no points. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter plot with median and interquartile lines | Charts and Charting in Excel | |||
Excel Scatter Plot | Charts and Charting in Excel | |||
how do I find the equation of a line using a scatter plot? | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |