Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
I have a simple plot with two points only, and added a trendline which fits
with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
Hi,
Use the text label provided by the Trendline equation. Once applied you can then link it to a cell. select the label and then in the formula bar type = and then click the required cell. This will create the required cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Need Help on axis problem in a chart" ft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
No, It didnt work,
I tried typing = then a cell destination. it just showed me what I typed. It did not take the vales from the cell. or IF I select the equation level and go to formula bar, the equation level just disappears. Is there any other way to get it to work ?? Thanks in advance "Andy Pope" wrote: Hi, Use the text label provided by the Trendline equation. Once applied you can then link it to a cell. select the label and then in the formula bar type = and then click the required cell. This will create the required cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Need Help on axis problem in a chart" ft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
Have a look here for details.
http://www.andypope.info/tips/tip001.htm I have tried it and it does work. Cheers Andy Need Help on axis problem in a chart wrote: No, It didnt work, I tried typing = then a cell destination. it just showed me what I typed. It did not take the vales from the cell. or IF I select the equation level and go to formula bar, the equation level just disappears. Is there any other way to get it to work ?? Thanks in advance "Andy Pope" wrote: Hi, Use the text label provided by the Trendline equation. Once applied you can then link it to a cell. select the label and then in the formula bar type = and then click the required cell. This will create the required cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Need Help on axis problem in a chart" soft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
Hey, that's a very neat trick Andy, thank you!!
For the benefit of the OP I'll explain what I did. Data setup: X values in A1:A5 Y values in B1:B5 In D7 put =SLOPE(B1:B5,A1:A5) In E7 put ="Slope = "&D7 Then click on the equation in the chart and the handles will show. Then I put this in the formula bar =Sheet1!$E$7 and hit enter. Jobs done! I then took it further and added this In D8 put =INTERCEPT(B1:B5,A1:A5) Then changed E7 to this ="Gradient = "&D7&CHAR(10)&"Y Intercept = "&D8 Which is much neater than the standard equation. I took it further again and put this in E7 ="Trendline equation is y = mx+c where"&CHAR(10)&"m = "& SLOPE(B1:B5,A1:A5)&CHAR(10)&"c = "&INTERCEPT(B1:B5,A1:A5) Which is interesting but not very practical, far better to put the formalae in other cells then just reference those cells like this, ="Trendline equation is y = mx+c where"&CHAR(10)&"m = "&D7&CHAR(10)&"c = "&D8 Once again thank you Andy, up until now I've been using a text box to display this, which works but is manual and as such I sometimes forget to change the text box after a source data change. Regards Martin "Andy Pope" wrote in message ... Have a look here for details. http://www.andypope.info/tips/tip001.htm I have tried it and it does work. Cheers Andy Need Help on axis problem in a chart wrote: No, It didnt work, I tried typing = then a cell destination. it just showed me what I typed. It did not take the vales from the cell. or IF I select the equation level and go to formula bar, the equation level just disappears. Is there any other way to get it to work ?? Thanks in advance "Andy Pope" wrote: Hi, Use the text label provided by the Trendline equation. Once applied you can then link it to a cell. select the label and then in the formula bar type = and then click the required cell. This will create the required cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Need Help on axis problem in a chart" osoft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
Hi,
Thanks for posting :) Cheers Andy MartinW wrote: Hey, that's a very neat trick Andy, thank you!! For the benefit of the OP I'll explain what I did. Data setup: X values in A1:A5 Y values in B1:B5 In D7 put =SLOPE(B1:B5,A1:A5) In E7 put ="Slope = "&D7 Then click on the equation in the chart and the handles will show. Then I put this in the formula bar =Sheet1!$E$7 and hit enter. Jobs done! I then took it further and added this In D8 put =INTERCEPT(B1:B5,A1:A5) Then changed E7 to this ="Gradient = "&D7&CHAR(10)&"Y Intercept = "&D8 Which is much neater than the standard equation. I took it further again and put this in E7 ="Trendline equation is y = mx+c where"&CHAR(10)&"m = "& SLOPE(B1:B5,A1:A5)&CHAR(10)&"c = "&INTERCEPT(B1:B5,A1:A5) Which is interesting but not very practical, far better to put the formalae in other cells then just reference those cells like this, ="Trendline equation is y = mx+c where"&CHAR(10)&"m = "&D7&CHAR(10)&"c = "&D8 Once again thank you Andy, up until now I've been using a text box to display this, which works but is manual and as such I sometimes forget to change the text box after a source data change. Regards Martin "Andy Pope" wrote in message ... Have a look here for details. http://www.andypope.info/tips/tip001.htm I have tried it and it does work. Cheers Andy Need Help on axis problem in a chart wrote: No, It didnt work, I tried typing = then a cell destination. it just showed me what I typed. It did not take the vales from the cell. or IF I select the equation level and go to formula bar, the equation level just disappears. Is there any other way to get it to work ?? Thanks in advance "Andy Pope" wrote: Hi, Use the text label provided by the Trendline equation. Once applied you can then link it to a cell. select the label and then in the formula bar type = and then click the required cell. This will create the required cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Need Help on axis problem in a chart" rosoft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show slope on a chart?
If you only have two points, why bother with a trendline? Format the series
to show a line connecting the markers, then use Andy's and Martin's suggestions to apply a label to one endpoint with the slope. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Need Help on axis problem in a chart" ft.com wrote in message ... I have a simple plot with two points only, and added a trendline which fits with the plotted line. I really need to show the slope of the trend line on the plot. But I dont want to show the equation or anything else. I am using a plot which should calculated and plot by itself with the change of inputs in the table(somewhere in the page), and need to show that slope value on the plot too. I can calculate slope in a cell somewhere on the sheet. Is there any way to show the value (calculated somwhere on the sheet) on the plot beside my plotted line. Either way would work. But I prefer to do it from the trendline. please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
Slope line in stacked area chart | Charts and Charting in Excel | |||
finding angle of slope... | Charts and Charting in Excel | |||
How can I visually display slope in an excel chart? | New Users to Excel | |||
Slope of graph? | Charts and Charting in Excel |