Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning data of multiple cells for lookup of mulltiple cells | Excel Discussion (Misc queries) | |||
how to find cells that refer to data in other cells in excel | Excel Discussion (Misc queries) | |||
how do i lookup and sum from serveral wkshts to a recap sht? | Excel Worksheet Functions | |||
How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |