Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default data in serveral cells

data is in several columns and rows. need to take this data and graph data
point against iits point in the line of data.
-3.7 -4.4 -5.8 -7.6 -10.1
-7.9 -8.8 -10.5 -12.8 -15.7
-12.8 -13.8 -15.9 -18.6 -22.2
-18.4 -19.5 -22 -25.3 -29.7
-25 -26 -28.9 -32.9 -38.1
How does one go about this?
--
gogreen
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default data in serveral cells

Insert/Chart/ Line (or what variety you want)/ Rows/ Finish
--
David Biddulph

"Reactor Engineer" wrote in
message ...
data is in several columns and rows. need to take this data and graph
data
point against iits point in the line of data.
-3.7 -4.4 -5.8 -7.6 -10.1
-7.9 -8.8 -10.5 -12.8 -15.7
-12.8 -13.8 -15.9 -18.6 -22.2
-18.4 -19.5 -22 -25.3 -29.7
-25 -26 -28.9 -32.9 -38.1
How does one go about this?
--
gogreen



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default data in serveral cells

Do you have 5 data series (one in each column, or one in each row)
Please tell us what the x-values are. Are they 1,2,3?
We can sort this out with just a bit more info from you
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Reactor Engineer" wrote in
message ...
data is in several columns and rows. need to take this data and graph
data
point against iits point in the line of data.
-3.7 -4.4 -5.8 -7.6 -10.1
-7.9 -8.8 -10.5 -12.8 -15.7
-12.8 -13.8 -15.9 -18.6 -22.2
-18.4 -19.5 -22 -25.3 -29.7
-25 -26 -28.9 -32.9 -38.1
How does one go about this?
--
gogreen



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
Returning data of multiple cells for lookup of mulltiple cells HELP on data reference formulas Excel Discussion (Misc queries) 1 October 29th 08 08:27 PM
how to find cells that refer to data in other cells in excel Aman Excel Discussion (Misc queries) 8 December 2nd 07 10:02 PM
how do i lookup and sum from serveral wkshts to a recap sht? MBI POOLS Excel Worksheet Functions 1 August 7th 06 07:32 PM
How to find multiple cells/replace whole cells w/data dcurylo Excel Discussion (Misc queries) 2 November 30th 05 08:06 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM


All times are GMT +1. The time now is 10:59 AM.

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

About Us

"It's about Microsoft Excel"