Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I want to know how can I graph equations from linear equations to quartic or
higher degree equations using excel charts utility? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Decide your expression(s) for Y as a function of X.
Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had
already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Did you use appropriate significant digits in your coefficients? Probably,
if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thanks Mr. Peltier. Yes I made an XY chart using curve lines... and the
digits in my coefficients were correct. I think I did everything ok. I mean I calculated the values of f(x) for each value of x in a range -10 to +10. The resulting values were exact... Then I did <Insert, Object,Chart, Scatter... and the resulting graph wasn't even remotely alike the one that you get in the graphic calculator. Thanks anyway... "Jon Peltier" wrote: Did you use appropriate significant digits in your coefficients? Probably, if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
raidven -
I don't understand. If you already have an XY (Scatter) chart with correct results, why are you choosing Insert | Object | Microsoft Graph Chart | ... ? - Mike http://www.mikemiddleton.com "raidven" wrote in message ... Thanks Mr. Peltier. Yes I made an XY chart using curve lines... and the digits in my coefficients were correct. I think I did everything ok. I mean I calculated the values of f(x) for each value of x in a range -10 to +10. The resulting values were exact... Then I did <Insert, Object,Chart, Scatter... and the resulting graph wasn't even remotely alike the one that you get in the graphic calculator. Thanks anyway... "Jon Peltier" wrote: Did you use appropriate significant digits in your coefficients? Probably, if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to graph functions and equations in excel | Charts and Charting in Excel | |||
How do I enter a quadratic and cubit-fit equations? | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
graph linear Algebra equations and inequalities | New Users to Excel |