I found this at JFWlite under hints/tricks..
Creating Charts with Excel and JFW
Here is an example.
say you're in excel and in column A, you have the names of sales reps going
from
A1 down to A10. then in column B, you have the amount each has sold that
month.
So, you have two lots of data, sales rep name and their sales.
go to the bottom cell,B10 and highlight up to the top using control shift
and up
after you have located yourself in B10.
Now go to the insert menu and arrow down until you hear chart.
Enter here and the chart wizard will start up. This is a four step wizard.
let's say your boss wants a pie chart.
In step one you are given a whole load of chart types you can choose from.
go to Pie and enter.
the second step of the wizard will then start and give you the co-
ordinates,cells, you have selected.
you keep pressing next button.
on the third step, you will be asked if you wish to assign label and
following
the steps within this step this is tricky but becomes easier with practice.
The
fourth step asks if you want to put the chart in the sheet or to a separate
document, this is up to you but I normally go for a separate document as you
can
then copy and paste into a word document and place text above or below the
chart.
You then click finish, and hey presto, a pie chart. Or indeed, any other
type
of chart you want.
If you are using a colour printer, the charts appear in colour, if not they
will
be printed in various shades of grey.
Also, while still in excel you can go to the view menu and into Zoom, to
make
the chart appear much larger on the printed sheet.
Some Windows Shortcuts for Excel
File Management
New Ctrl-N
Open Ctrl-O
Print Ctrl-P
Save Ctrl-S
Save As F12
Editing
Undo Ctrl-Z
Repeat last command F4
Copy Ctrl-C
Cut Ctrl-X
Paste Ctrl-V
Find Ctrl-F
Replace Ctrl-H
Goto F5
Insert blank cell Ctrl-Shift-+
Delete cell selection Ctrl-Minus sign
Edit cell note Shift-F2
moving
Move down to next page of data Page Down
Move up to previous page of data Page Up
Move across to next page of data Alt-Page Down
Move across to previous page of data Alt-Page Up
Go to next worksheet Ctrl-Page Down
Go to previous worksheet Ctrl-Page Up
Move up through a selection Shift-Enter
Move right through a selection Tab
Move left through a selection Shift-Tab
Formatting
Annotate a cell Shift-F2
Format selected element Ctrl-1
Check spelling F7
Create chart F11 (or Alt-F1)
Enter date Ctrl-;
Enter time Ctrl-:
Scroll between relative, absolute,
and mixed references - F4
Selecting Ranges
All cells with notes Ctrl-Shift-?
Rectangular range of cells around
active cell Ctrl-*
Cells with formulas that refer
directly to active cell Ctrl-]
All cells within formulas that refer
to active cell Ctrl-Shift-{
Only visible cells in current selection Alt-;
Data Formatting
Apply general number format Ctrl-Shift-~
Format as currency Ctrl-Shift-$
Apply percentage format Ctrl-Shift-%
Apply exponential number format Ctrl-Shift-^
Format number as date Ctrl-Shift-#
Format number as time Ctrl-Shift-@
Apply two-decimal place format Ctrl-Shift-!
Apply outline border Ctrl-Shift-&
Remove all borders Ctrl-Shift-_
Hide rows Ctrl-9
Unhide rows Ctrl-Shift-(
Hide columns Ctrl-0
Unhide columns Ctrl-Shift-)
Jaws Keystrokes Excel
DESCRIPTION KEYSTROKE
Informational Keystrokes for Columns
Read first cell in column ALT+1
Read second cell in column ALT+2
Read third cell in column ALT+3
Read fourth cell in column ALT+4
List cells in current column CTRL+SHIFT+C
Read column total INSERT+NUM PAD ENTER
Say column title ALT+SHIFT+C
Informational Keystrokes for Rows
Read first cell in row ALT+CTRL+1
Read second cell in row ALT+CTRL+2
Read third cell in row ALT+CTRL+3
Read fourth cell in row ALT+CTRL+4
List cells in current row CTRL+SHIFT+R
Read row total INSERT+DELETE
Say row title ALT+SHIFT+R
Miscellaneous Informational Keystrokes
Describe cell border ALT+SHIFT+B
Lists cells at page break CTRL+SHIFT+B
List cells with comments CTRL+SHIFT+' (APOSTROPHE)
Read cell comment ALT+SHIFT+' (APOSTROPHE)
List cells with data visible on screen CTRL+SHIFT+D
List defined monitor cells CTRL+SHIFT+M
List worksheets CTRL+SHIFT+S
Say range of cells visible in active window ALT+SHIFT+V
Read hyperlink ALT+SHIFT+A
Report gridline status ALT+SHIFT+G
Say active cell coordinates INSERT+C
Say excel version (Excel 95 only) CTRL+SHIFT+V
Say contents of focus rectangle INSERT+N
Say cell font and attributes INSERT+F
Say formula CTRL+F2
Read spelling error and suggestion INSERT+F7
Navigation Keystrokes
Move to prior screen in spreadsheet ALT+PAGE UP
Move to next screen in spreadsheet ALT+PAGE DOWN
Next Sheet CTRL+PAGE DOWN
Prior Sheet CTRL+PAGE UP
Move down to the edge of current data region CTRL+DOWN ARROW
Move up to the edge of current data region CTRL+UP ARROW
Move left to the edge of current data region CTRL+LEFT ARROW
Move right to the edge of current data region CTRL+RIGHT ARROW
Selection Keystrokes
Select column CTRL+SPACEBAR
Select hyperlink CTRL+SHIFT+H
Select region CTRL+SHIFT+8
Select row SHIFT+SPACEBAR
Select worksheet objects CTRL+SHIFT+O
Collapse selection to current cell SHIFT+BACKSPACE
Configuration Keystrokes
Read monitor cell ALT+SHIFT+1 THROUGH 0
Set monitor cell ALT+CTRL+SHIFT+1 THROUGH 0
Clear definitions of monitor cells CTRL+SHIFT+DELETE
Formula input mode = (EQUALS)
AutoFilter CTRL+SHIFT+A
AutoSum ALT+= (EQUALS)
Date stamp CTRL+; (SEMICOLON)
Time stamp CTRL+SHIFT+; (SEMICOLON)
Close Office Assistant CTRL+INSERT+F4
link Detailed Descriptions of Keystrokes
--~--~---------~--~----~------------~-------~--~----~
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Address for the list archives:
http://www.mail-archive.com/jaws-users-list%40googlegroups.com/
In order to contact the management team simply fill out the following form
found at:
http://www.jaws-users.com/contact.php
You received this message because you are subscribed to the Google Groups
"JAWS Users List" group.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/jaws-users-list?hl=en
-~----------~----~----~----~------~----~------~--~---
