Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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



--
:)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default 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



--
:)

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default 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



--
:)

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
Graphing data not yet entered Rich W. Charts and Charting in Excel 3 July 13th 07 06:32 PM
Selective graphing of data. goslings Charts and Charting in Excel 0 March 31st 07 09:38 AM
How do you skip graphing some data? Kim Excel Discussion (Misc queries) 7 December 14th 06 02:09 AM
graphing data of different frequencies Bob Charts and Charting in Excel 3 June 12th 06 08:17 PM
Help with graphing log data Petrov27 Charts and Charting in Excel 2 January 19th 05 09:17 PM


All times are GMT +1. The time now is 10:08 PM.

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

About Us

"It's about Microsoft Excel"