Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
carole
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing data from several sheets, to one chart Martin Thorgaard Charts and Charting in Excel 2 January 6th 05 03:07 PM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"