[Blindmath] {Spam?} RE: Graphing in excel

Sun Feb 21 23:04:13 UTC 2016

Hello.

I heard a paper on the use of NVDA at a recent  conference in Japan. See
http://workshop.sciaccess.net/DEIMS2016/index.html

I'm not sure if the things you want are possible, but you might try to track down the authors who are working on improving the accessibility of Excel graphs for NVDA users.

Jonathan

-----Original Message-----
From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of Anna via Blindmath
Sent: Monday, 22 February 2016 11:57 a.m.
To: Blind Math list for those interested in mathematics
Cc: annajee82 at gmail.com
Subject: Re: [Blindmath] {Spam?} RE: Graphing in excel

The only way I know to do it is to right click with the mouse on a data point on the graph, a dialog box opens and you can do lots of things, including R squared values and such.  
With a screen reader, I have no idea.  That is what I am trying to figure out.  
It is unfortunate, right now, it seems that a sighted person is needed just to click on the graph within the worksheet so that a screen reader can work within it.  That's a little ridiculous. 
There must be some way around this.

Anna E Givens

> On Feb 22, 2016, at 3:19 PM, Trevor Attenberg via Blindmath <blindmath at nfbnet.org> wrote:
> 
> My impression was that there are graphing options in Excel that will 
> generate R^2 values, p vals, and so forth right there on the spot. My 
> trouble has been extracting the information from the section of the 
> excel sheet where the graphing appears. I wonder if the JAWS pc cursor 
> or the NVDA and Window Eyes equivalents would be of service in getting 
> you in the right area of the worksheet. I've not had much luck in this 
> regard. By the way, could you tell me how one does generate r^2 and 
> respective p vals from data columns in Excel? I do know the process in R.
> Best,
> Trevor
> 
> 
> -----Original Message-----
> From: Blindmath [mailto:blindmath-bounces at nfbnet.org] On Behalf Of 
> Allan Mesoga via Blindmath
> Sent: Sunday, February 21, 2016 11:01 AM
> To: Blind Math list for those interested in mathematics
> Cc: Allan Mesoga
> Subject: Re: [Blindmath] Graphing in excel
> 
> I don't know how to insert equations on the graph but copying equation 
> from cell to cell you may press ctrl+c on cell where your equation is 
> located then go to cell wher you want it to copy and press ctrl+v to 
> paste it or press application key and select paste special to give more options.
> Hope it helps.
> 
>> On 2/21/16, Sarah Jevnikar via Blindmath <blindmath at nfbnet.org> wrote:
>> 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>
>> 
>> 
>> _______________________________________________
>> 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/allan.mesoga%4
>> 0
>> gmail.com
>> BlindMath Gems can be found at
>> <http://www.blindscience.org/blindmath-gems-home>
> 
> 
> --
> Allan R. Mesoga
> Copyreader
> Learning Resources Production Division Bureau of Learning Resources 
> Department of Education Mobile number:  09198861145 Personal website:  
> http://www.armesoga.xtreemhost.com/
> 
> _______________________________________________
> 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/tattenberg%40gm
> ail.co
> m
> BlindMath Gems can be found at
> <http://www.blindscience.org/blindmath-gems-home>
> 
> 
> _______________________________________________
> 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/annajee82%40gma
> il.com BlindMath Gems can be found at 
> <http://www.blindscience.org/blindmath-gems-home>

_______________________________________________
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/a.j.godfrey%40massey.ac.nz
BlindMath Gems can be found at <http://www.blindscience.org/blindmath-gems-home>