#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 287
Default finding x intercepts

I have a formula and have created a list of coordinates and have graphed them
with a line chart and now i need to find the x intercepts of the line.
Thankyou
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default finding x intercepts

If you already have the equation, you don't need the points. Just solve the
linear equation. You need algebra, not Excel.
--
Gary''s Student - gsnu200713
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default finding x intercepts

But maybe teacher wants to show that the 'zero of a function' is the same as
its solution.
The OP did not tell us anything about the equation so we cannot offer much
advice.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
If you already have the equation, you don't need the points. Just solve
the
linear equation. You need algebra, not Excel.
--
Gary''s Student - gsnu200713



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default finding x intercepts

the answer depends on the equation. To find x-intercepts you need to set Y =
0 and solve for X. This may be simple or complex. Post the equation if you
have problems. There are ways to estimate the X intercepts for complex
equations. You can always write a program. also post how accruate you need
your answer (number of decimal places).

"Aaron" wrote:

I have a formula and have created a list of coordinates and have graphed them
with a line chart and now i need to find the x intercepts of the line.
Thankyou

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Max or Min Value [email protected] Excel Discussion (Misc queries) 4 November 24th 06 09:39 AM
linear and exponential graphs and x,y intercepts [email protected] Charts and Charting in Excel 3 August 7th 06 02:29 PM
Finding Row fak119 Excel Discussion (Misc queries) 3 May 18th 06 05:54 PM
finding the "end" Julia New Users to Excel 2 September 1st 05 02:38 AM
finding the last value Simon Shaw Excel Discussion (Misc queries) 8 January 16th 05 10:02 AM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"