ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   graphing data using excel (https://www.excelbanter.com/excel-discussion-misc-queries/159383-graphing-data-using-excel.html)

Mini

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



--
:)

OssieMac

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



--
:)


OssieMac

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