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

Mon Feb 22 01:36:21 UTC 2016

Anna,

The key to selecting data points on a chart without a mouse may lie 
in the macro recorder.

If you can record someone clicking on a data point with the macro 
recorder on, then view the resulting macro, it should be a concise 
readable line or several of Visual Basic.

For example (I'm just free-wheeling here):

Chart1.Select.Cell("a1").Properties

I haven't been fully down this road myself yet but that's the 
direction I was taking when needing to interact with visual charts.

Ben

At 05:57 PM 2/21/2016, you wrote:
>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%40
> >> 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%40gmail.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%40gmail.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/brhbrhbrh%40gmail.com
>BlindMath Gems can be found at 
><http://www.blindscience.org/blindmath-gems-home>