I'm trying to create a single 'line type' chart from two sets of data. The 'x' axis for both is the distance along carriageway, the 'y' data are values of skidding resistance. The problem is that the two sets of data are recorded at different locations on the carriageway and when I try to join the data sets there are gaps in the lines. e.g.
Distance (x) Data Set 1 'y1' Data Set 2 'y2'
100 2 2
125 1
150 2
175 3 2
200 2
225 3
250 1 1
And so on, is there a way to create a 'line type' chart without gaps in the lines where there are gaps in the data?
Bookmarks