[Blindmath] Graphing in excel

[Sarah Jevnikar]

Hi there,
I've fought with Excel graphs and am afraid I've thrown in the towel and
gotten sighted assistance. I'm sure others here will have better ideas.

As for the formulae question, you can do the following.
1. Type the formula in the first cell you want it in and press Enter for it
to be applied.
2. Press up arrow to return to the cell you just typed in.
3. Hold down the shift key and press down arrow until you reach the last
cell the formula should go in.
4. Press control-D. This will fill the column of cells with the formula the
first one contained.
Notes:
1. If the column of cells is large, this can become tedious. You can type
Control-g (for Go To) and type the range of cells (C2:C52, for instance).
Then cells C2 through C52 are selected and you can type Control-d.
2. The formula will change based on the cell reference. For example, if your
initial formula in cell C1 was
=A1+B1
Your formula in C2 would be
=A2+B2
If you didn't want this to change, you'd use $. For instance,
=$A$1+B1 would cause cell A1 to always be added to other cells (B2, B3,
etc.)
3. You can do the same thing with formulae or information along a row:
Select for instance A1:Z1 with Control-g or shift+right arrow, with contents
in A1, and hit Control-r.

I hope this helps,
Sarah


-----Original Message-----
From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of Anna via
Blindmath
Sent: February-21-16 12:18 AM
To: nabs-l at nfbnet.org; Nfb Science Email; blindmath at nfbnet.org
Cc: annajee82 at gmail.com
Subject: [Blindmath] Graphing in excel

I use JAWS and Excel 2010.  I have to make a bunch of graphs and have to use
Excel.  I know how to make the graphs but I do not know how to insert the
equation for it and insert the R squared value and stuff like that.  I know
that with a mouse you right click on a data point on the graph and then you
can do it.  But I don't think you can do that with JAWS so how could I do
it? 
Also, I would like to insert some equations into some cells and drag it down
to other cells, instead of typing in the same equation over and over in a
bunch of cells.  With the mouse it's simply click, hold, and drag.  How do
you do it with JAWS?
I would be very grateful for help. And if there is a more appropriate place
for me to be asking this question, please let me know.

Thanks!

Anna E Givens


_______________________________________________
Blindmath mailing list
Blindmath at nfbnet.org
http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
To unsubscribe, change your list options or get your account info for
Blindmath:
http://nfbnet.org/mailman/options/blindmath_nfbnet.org/sarah.jevnikar%40mail
.utoronto.ca
BlindMath Gems can be found at
<http://www.blindscience.org/blindmath-gems-home>