Re: Creating/ reading Pivot Tables Excel
- From: "Dave 'SqueezeBox' Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 5 Jun 2008 07:54:38 -0700
Bill,
A pivot table that is already created is just the same as a standard
spreadsheet, provided that it's not in chart form. You should be able to
move cell-to-cell and read the contents.
The pivot table wizard (not accessible) allows the creation of a table that
is an automatic compilation of data and summarized with totals, in a very
accounting-like format. If we could use it could save a lot of time creating
reports.
Dave
----- Original Message -----
From: "Bill Tipton" <bill.tipton@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Wednesday, June 04, 2008 2:14 PM
Subject: RE: Creating/ reading Pivot Tables Excel
Hi Artur and all,
How do you read a pivot table with the latest version of Jaws in Excel 2003?
I have a Excel file where I move down to row 2 and Jaws says pivot table.
Then Jaws sort of freezes for a bit.
Then I can't seem to be able to read anything from this view.
Is there special Jaws keystrokes to read the pivot table?
Thanks,
Bill
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
Of Artur Räpp
Sent: Saturday, May 31, 2008 8:41 AM
To: jfw@xxxxxxxxxxxxx
Subject: RE: Creating Pivot Tables Excel 2003
Hello Dave,
I am using Excel 2003.
Excel 2003 shows 2 toolbars for Pivot Tables.
On second pivot table toolbar are only 3 choices:
Pivot Table field list - You can choose with arrow keys
Pivot Table choices (row area, column area ...) you can choose with arrow
keys
And add to button, you can activate this button with Enter key.
You can move between these 3 choices with tab key.
In short
1. Open data menu, chose Pivot Tables, press Enter
2. Move with tab key to finish button and press space bar or press ALT+F
3. Press alt key (activate menu bar)
4. Press ctrl+tab until the Pivot Table toolbar
5. Press tab key until
Show field list button. Ensure that this button is selected, JAWS says
pressed. If not then press Enter.
6. Press again ctrl+tab to move on the toolbar with Pivot Table field list
(second pivot table toolbar)
7. Choose in the first list box Pivot Table field, move with tab key to
second list box, choose Pivot Table area, move with tab key to Add to button
and press Enter to add this field to selected pivot table area.
Press again tab key, choose next field for Pivot Table...
HTH
Artur
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
Of Dave 'SqueezeBox' Carlson
Sent: Saturday, May 31, 2008 3:55 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: Creating Pivot Tables Excel 2003
Artur,
How do you navigate in the drag-and-drop dialog when creating the pivot
table?
Dave
----- Original Message -----
From: "Artur Räpp" <artur1248@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Saturday, May 31, 2008 1:13 AM
Subject: RE: Creating Pivot Tables Excel 2003
Hi,
This is quite easy.
Open Pivot Table dialoog. Move to finiš button and press Enter.
Then move to menu bar - press alt key. with ctrl+tab key move to Pivot Table
toolbar.
HTH
Artur
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
Of Bill Tipton
Sent: Tuesday, May 20, 2008 6:02 AM
To: jfw@xxxxxxxxxxxxx
Subject: Creating Pivot Tables Excel 2003
Hello all,
How do I create Pivot tables in Excel 2003 with Jaws 9.0.2152?
I have never attempted creating pivot tables in past and could use any
pointers to help me.
Once I create the pivot table how can I read the pivot table with Jaws to
verify I did it correctly?
Thank you.
Bill
Bill Tipton
Bill.tipton@xxxxxxxxxxx
Blog: http://globaldialoguecenter.blogs.com/disabilities/
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/ Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx To unsubscribe
from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the
word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the
list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
