Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extrapolation of a point on a graph/chart.
I have constructed a graph which consists of plots joined by a line (basic
line graph). How do i find the value of a point on that graph (if x = 0.37 then y = ?) other than printing the graph off and manually drawing the lines myself? Any pointers would be most welcome! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extrapolation of a point on a graph/chart.
"ExcelCretin" wrote in message
... I have constructed a graph which consists of plots joined by a line (basic line graph). How do i find the value of a point on that graph (if x = 0.37 then y = ?) other than printing the graph off and manually drawing the lines myself? Any pointers would be most welcome! If you've fitted a straight line, use the LINEST function to get the gradient and intercept of that line, and then use those coefficients to work out the y value for your x value. -- David Biddulph |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extrapolation of a point on a graph/chart.
Thanks for the prompt response David, unfortunately I constructed a 'scatter'
with lines. does this make a difference? "David Biddulph" wrote: "ExcelCretin" wrote in message ... I have constructed a graph which consists of plots joined by a line (basic line graph). How do i find the value of a point on that graph (if x = 0.37 then y = ?) other than printing the graph off and manually drawing the lines myself? Any pointers would be most welcome! If you've fitted a straight line, use the LINEST function to get the gradient and intercept of that line, and then use those coefficients to work out the y value for your x value. -- David Biddulph |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extrapolation of a point on a graph/chart.
Use the LINEST function to get the coefficients in worksheet cells. For
more search the XL help for LINEST, -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have constructed a graph which consists of plots joined by a line (basic line graph). How do i find the value of a point on that graph (if x = 0.37 then y = ?) other than printing the graph off and manually drawing the lines myself? Any pointers would be most welcome! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pin a callout data point | Charts and Charting in Excel | |||
Point Assessment Calc? | Excel Discussion (Misc queries) | |||
format inplied decimal point | Excel Discussion (Misc queries) | |||
how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel | |||
decimal point override does not work | Excel Discussion (Misc queries) |