Perhaps you can use two series. Select both of the columns (if your series
are in columns) as well as the X data column. Use the Ctrl key as you
select if they're not adjacent. If the value ranges are different, assign
one or the other to the other Y axis (right click the line, FOrmat data
series - Axes).