ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I use Algebra grafting? (https://www.excelbanter.com/excel-discussion-misc-queries/145905-how-do-i-use-algebra-grafting.html)

ga_snowtaz

How do I use Algebra grafting?
 
How do I get Excel to do graphing?

JLatham

How do I use Algebra grafting?
 
In pre-2007 Excel start with Insert | Chart and go from there. Excel Help
has lots of info on it.
In Excel 2007, Charts are a group on the Insert ribbon tab. Again, Help
will be your friend for a while.

"ga_snowtaz" wrote:

How do I get Excel to do graphing?


Bernard Liengme

How do I use Algebra grafting?
 
Make an XY chart. Do not be lead astray by the name "LINE" chart.
Put you x-values in A1:A10 (for example); your y-values in B1:B10
Put the cursor over any on the cells A1:B10 and use the chart wizard.
The y-values could be formulas; so B1 could be =4*A1+3 and copied down to
B10.
Now you get a plot of part of a parabola
Come back with further questions
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ga_snowtaz" wrote in message
...
How do I get Excel to do graphing?




David Biddulph[_2_]

How do I use Algebra grafting?
 
In that case, a straight line rather than a parabola, Bernard? :-)

Try =4*A1^2 for a parabola.

But of course your advice to the OP is good, particularly avoiding "line
chart" when you need XY.
--
David Biddulph

"Bernard Liengme" wrote in message
...
Make an XY chart. Do not be lead astray by the name "LINE" chart.
Put you x-values in A1:A10 (for example); your y-values in B1:B10
Put the cursor over any on the cells A1:B10 and use the chart wizard.
The y-values could be formulas; so B1 could be =4*A1+3 and copied down to
B10.
Now you get a plot of part of a parabola
Come back with further questions
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ga_snowtaz" wrote in message
...
How do I get Excel to do graphing?







All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com