![]() |
graphing data using excel
I need to graph the following and i have no clue on how to do it. I need a
line graph. Can anyone help? 1st decay 2nd decay 3rd decay 4th decay 5th decay 6th decay Trial 1 54 30 18 8 4 1 Trial 2 54 29 16 9 4 1 Class 54.5 29.5 17 9 4 1 -- :) |
graphing data using excel
Just select all the data from the top left corner to the bottom right corner
then:- In xl2007 version: Select the Insert Ribbon then Line Chart then select a chart with multiple lines with either one without dots for each value or one with the dots at each value and then click finish. In pre xl2007 versions: Select menu item Insert-Chart-Standard types tab-Line and then the type of line chart you want. Regards, OssieMac "mini" wrote: I need to graph the following and i have no clue on how to do it. I need a line graph. Can anyone help? 1st decay 2nd decay 3rd decay 4th decay 5th decay 6th decay Trial 1 54 30 18 8 4 1 Trial 2 54 29 16 9 4 1 Class 54.5 29.5 17 9 4 1 -- :) |
graphing data using excel
When I said to select all the data I should have said to include the column
headers (1st decay etc) and also the row titles (Trial 1 etc). The first cell top left of your selection will be blank based on the data sample in your post. Regards, OssieMac "OssieMac" wrote: Just select all the data from the top left corner to the bottom right corner then:- In xl2007 version: Select the Insert Ribbon then Line Chart then select a chart with multiple lines with either one without dots for each value or one with the dots at each value and then click finish. In pre xl2007 versions: Select menu item Insert-Chart-Standard types tab-Line and then the type of line chart you want. Regards, OssieMac "mini" wrote: I need to graph the following and i have no clue on how to do it. I need a line graph. Can anyone help? 1st decay 2nd decay 3rd decay 4th decay 5th decay 6th decay Trial 1 54 30 18 8 4 1 Trial 2 54 29 16 9 4 1 Class 54.5 29.5 17 9 4 1 -- :) |
All times are GMT +1. The time now is 02:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com