how to add numbers from different areas in chart and importing forms from word
 

can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the total
of these ten- is there a way of obtaining this by selecting them
without putting in all the numbers separately somewhere to arrive at a
total.

Can a table be imported from word into excel. i.e a multi row table
with 2 o r 3columns and it visually will look like its in normal view
word but in excel. can someone tell me.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=550818

how to add numbers from different areas in chart and importing for
 

Charts usually represent data that exist in cells. First find these cells
and then, while holding done the CNTRL key, click on the cells of interest.
The sum should appear at the very bottom of the Excel window.


For your second question, click inside the table in Word and pull-down:
Table Select Table
then Edit Copy

In Excel, click in a cell and paste.
--
Gary's Student


"carole" wrote:


can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the total
of these ten- is there a way of obtaining this by selecting them
without putting in all the numbers separately somewhere to arrive at a
total.

Can a table be imported from word into excel. i.e a multi row table
with 2 o r 3columns and it visually will look like its in normal view
word but in excel. can someone tell me.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=550818