How do you make a graph on excel when you have 3 parts of data?

Question

I need to create a line graph that can show the time passing, the units that you see at each duration of time (i.e. 5 mL at 10 minutes), and 3 lines to show the 3 experiments that were taking place at the time, for comparison.

Answer 1

Leave cell A1 blank

In A2 to A? put your time intervals

In B1 put a label for your 1st experiment e.g. Exp 1

In B1 to B? put your values for the first experiment for each time point in column A

Do the same for columns C and D for the 2nd and 3rd experiments respectively

Select all your cells from A1 to D?

Make an XY Scatter chart: sub-type data points with connected lines (not a "Line" chart)



Note: if your "time" values in column A are just increments of minutes, you can just put them in as integers e.g. 5, 7, 10... etc. If your time values are specific minute:second time intervals e.g. 05:33 (5 minutes and 33 seconds), you will have to enter them as a time format that excel recognizes like 05:33:00. This is important for the x axis to have the correct time intervals and scale.



You can right-click on any value on the chart's x-axis and custom format the time interval and scale. You will have to understand that Excel interprets "Time" as serial time (the decimal portion of one day) and make your adjustments based on serial time.

.

Answer 2

I tried it briefly right now and it seems to have worked. You'd have 4 columns, 1st - Time 2nd - Experiment 1, 3rd - Exp 2 and 4th - Exp 3



Then insert a pivot-chart. Select all your data, once the pane to the right opens, drag the time column top the top box to the axis field down the bottom and drag the other 3 to the values field. It doesn't matter if it says sum, because there is only 1 reading per time interval, it'll still be correct. Change the chart type to line and you're set.

Answer 3

Label the data you want to graph. In Row 1, type the labels for each piece of data you plan to graph. For example, type “Month” in cell A1 and “Units” in cell B1.



Step 2



Data for graphEnter the data that you want to graph. Excel needs you to provide the data that will be included in the graph. Under the labels you have set up in each row, type the information you want to graph. For example, type the months of the year under the heading in Column A (“Jan” in A2) and the units under the heading in Column B to correspond with the months in Column A.



Step 3Open the chart wizard window. From the menu bar, click "Insert" and "Chart."



Step 4



Chart wizardSelect the type of graph you want to make. Under "Chart Type," click on the type of chart you want to make. Then click to select the particular type of graph under chart sub-type. Click “Next.”



Step 5



Chart wizardSelect the range for the data to be included in the graph. Excel defaults to capture the data in the spreadsheet. If Excel does not default to capture the data, then click and drag your mouse over the data to be included in the graph. Click “Next.”



Step 6



Chart wizardDefine graph options. Excel 2003 provides several tabs to define graph options, such as to define where to put the legend, what information should be tracked on which axis and what the title of the graph should be. Make your selections and then click “Next.”



Step 7



Chart wizardDefine where to save the graph. The default is to save the graph in the current spreadsheet. Click the radio button for your choice and then click "Finish." The graph appears where you told Excel to make it.



Step 8



Graph using ExcelChange the text on the graph, if needed. If you want to change the title or other text on the graph, click on the text you want to change and then type in your changes.





this one is operating in Office 2003. hope you can follow it.

Answer 4

i'm used to artwork with an older version of Excel, so not sure, yet supply it a attempt: a million) as delimiter do no longer placed ' ' (area) yet '" "' (double quote area double quote). shop each and each of something of the technique like your colleague reported. OR 2) possibly the column devider on your information is in fact no longer an area (like it style of feels) yet a TAB subsequently you ought to in all probability use TAB is delimiter. OR 3)placed your information in a texteditor like Notepad, Wordpad (pay attention: some editors have optimal style of rows/information it could handle, make constructive all information is definitely there) or be conscious. Then save the record, supply it a recognition yet maximum extreme save it as ".txt". close the record. Now bypass to Excel and import (look in help in dwelling house windows the place to try this) the .txt record (in simple terms commencing the .txt record in Excel is in all probability no longer be stable sufficient). If function in Excel has no longer replaced to lots, you would be waiting to (and EXCEL asks you) opt for how information could desire to be imported. opt for "fastened" and placed marking factors at 6 and seven. this manner 3 columns would be made for positions a million as much as six, 6 as much as 7, 7 as much as end. opt for "quantity" in case you have in simple terms imported information itself. If additionally headers is imported, wiser to opt for "text fabric" or "varchar" (a type of could be reported). If import itself then went high-quality, you may choose/could desire to format the columns to show all numbers (digits) the appropriate way. choose you stable success