Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
line graphs in excel | Excel Discussion (Misc queries) | |||
line graphs in excel | Excel Worksheet Functions | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Line graphs with null values | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |