LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
baffledbrewer
 
Posts: n/a
Default How do i get lines on a line graph?


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

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

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

Thanks

Martyn


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

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

 
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
How do i get lines on a line graph? baffledbrewer Charts and Charting in Excel 2 June 4th 06 01:31 PM
Combine stacked column and line chart w/series lines ancillaries Charts and Charting in Excel 1 April 7th 06 11:51 PM
Automatically adding Vertical lines after certain points in line graph matthoffman33 Charts and Charting in Excel 4 March 7th 06 01:50 AM
Possible to Add Horizontal Line to Embedded Graph via VBA? TimSchwaar Charts and Charting in Excel 5 August 29th 05 11:41 PM
line graph ratio Charts and Charting in Excel 1 June 23rd 05 12:41 AM


All times are GMT +1. The time now is 12:07 AM.

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"