PC Review


Reply
Thread Tools Rate Thread

How do i get lines on a line graph?

 
 
baffledbrewer
Guest
Posts: n/a
 
      4th Jun 2006

I am trying to plot a number of series of data on the same graph. It i
experimental data with 'time' as the x axis. Measurements of th
experimental data were taken at 4 hour intervals, but they were not al
started at the same time. This means that the values of time in th
table must increment by 1 but there will not be an experimental valu
for each hour because a measurement was not taken. The data table i
included in a word file attachment.

When i plot a line graph or scatter graph of the points, there is not
line going through the points. I have done some experimenting an
concluded that this is because there are not values for some of th
times on the x axis.

Does anyone know of a way i can represent this data, with lines, all o
one graph?

Thanks

Marty

+-------------------------------------------------------------------
|Filename: Baffledbrewer.doc
|Download: http://www.excelforum.com/attachment.php?postid=4847
+-------------------------------------------------------------------

--
baffledbrewe
-----------------------------------------------------------------------
baffledbrewer's Profile: http://www.excelforum.com/member.php...fo&userid=3507
View this thread: http://www.excelforum.com/showthread.php?threadid=54825

 
Reply With Quote
 
 
 
 
MartinW
Guest
Posts: n/a
 
      4th Jun 2006
Hi baffledbrewer,

Can you explain your data in more detail?
What is
2.00.8
2.10.8
2.60.9
etc.

What measurements are your x and y values in?


 
Reply With Quote
 
baffledbrewer
Guest
Posts: n/a
 
      4th Jun 2006

Sorry, the next post explains in more detail with an attachement but i
have been given a response by another member and my problem is now
resolved.

Thank you for your time though

Martyn


--
baffledbrewer
------------------------------------------------------------------------
baffledbrewer's Profile: http://www.excelforum.com/member.php...o&userid=35074
View this thread: http://www.excelforum.com/showthread...hreadid=548259

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i get lines on a line graph? baffledbrewer Microsoft Excel Charting 2 4th Jun 2006 01:31 PM
Line Graph with 2 lines =?Utf-8?B?TmVlZCBoZWxwIG1ha2luZyBsaW5lIGdyYXBoIHdp Microsoft Excel Charting 5 19th May 2006 08:42 PM
Different lines in a spreadsheet on the same line in graph? =?Utf-8?B?TGVpc2hhIFBoaWZlcg==?= Microsoft Excel Charting 1 9th May 2006 08:42 PM
I can't get the lines to connect on my line graph =?Utf-8?B?c29sZXNtYXRl?= Microsoft Excel Charting 1 9th Nov 2005 10:47 AM
Re: Broken Lines in Line Graph Andy Pope Microsoft Excel Charting 1 2nd Jul 2003 12:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:22 PM.