View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Interpreting graph of a slope

Since this is a straight line, you need two points. In A1 and A2 enter the X
endpoints, that is, -10 and 10. In B1 enter the formula that calculates Y
from X:

=2*A1-3

Copy this cell, select B2, and paste. The range will look like this:

-10 -23
10 17

Select this range and go to the Chart Wizard (Insert menu Chart, or the
little button that looks like a chart on the Standard toolbar). In step 1
choose an XY chart, and select a subtype that has a connecting line. To get
the X and Y axes to show the ranges you want, double click on either, click
on the Scale tab, and enter appropriate values for min and max.

This might not be necessary, I don't know what exactly your assignment is,
but to show this relationship for the range -10<=Y<=10, you have to
rearrange the formula to determine how to compute X from Y.

Y = 2X - 3
Y + 3 = 2X
(Y + 3)/2 = X

Now as above, put -10 and 10 into E1 and E2. In D1 put this formula:

=(E1+3)/2

This produces the following range in D1:E2:

-3.5 -10
6.5 10

Copy D1, select D2, and paste. Make an XY chart as above.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Graphing a function" <Graphing a wrote
in message ...
I am studying pre-calc as a hobby - on my own.
I need to graph the function y=2x-3 in the following window:
(a) -10<=x<=10 by -10 <=y<=10
How do I enter this information for an excel chart?
Thanks, JNeal