LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Stacey
 
Posts: n/a
Default Q about Line Graphs


I encountered a problem while I was trying to plot a line graph with
several lines. My data looks something like this:


T, Line1, Line2, Line3
0, 0, 0, 0
1, 2, x, x
2, 3, 4, x
3, x, x, 5
4, 6, 9, 6

Where the x-axis is time (min) and the y-axis is volume total. My
problem is that since there are no values in certain places (as
designated by 'x'), the lines will not join up to the markers. The
reason I do not want to fill in the boxes with the previous value is
because there will be a marker at every single point. So how can I
connect the lines without adding redundant values?

Thanks, Stacey


--
Stacey
------------------------------------------------------------------------
Stacey's Profile: http://www.excelforum.com/member.php...o&userid=24201
View this thread: http://www.excelforum.com/showthread...hreadid=379320

 
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
line graphs in excel karl gauss Excel Discussion (Misc queries) 1 March 17th 05 11:55 AM
line graphs in excel karl gauss Excel Worksheet Functions 1 March 17th 05 11:55 AM
Line or bar graphs for tracking stocks profit and loss. Mocity Charts and Charting in Excel 1 January 21st 05 01:21 AM
Line graphs with null values Darren Hagarty Charts and Charting in Excel 3 January 12th 05 09:02 AM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 06:16 PM


All times are GMT +1. The time now is 12:02 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"