Problem charing w/line graph when a series has missing data points

I'm trying to graph the 2 series below on a Line graph chart using Excel. The problem is I am trying to use an x- scale starting on 3/21 and ending on 4/2.

So I want Series on to graph 3228.8356 on the 3/21/08 x-axis point and 3229.3098 on the 3/23/08 axis point. Is this possible? Is it also possible to have all the Series 1 points connected on a line graph.

Series 2 presents another problem: The data isn't taken on the same days all the time. IE it has data taken on 3/24 whereas series 1 did not.

Any tips to accomplish this? I've spent a large amount of time on this trying to figure it out.

SERIES 1
3/21/08 3228.8356
3/23/08 3229.3098
3/25/08 3227.8971
3/27/08 3226.7427
3/29/08 3228.3647
3/31/08 3227.1972
4/2/08 3227.05

SERIES 2
3/21/08 3230.9656
3/23/08 3231.8488
3/24/08 3235.2461
3/27/08 3234.8028
3/29/08 3234.8922
3/31/08 3234.8061
4/2/08 3232.7155

Exactly! Thanks a bunch.

Already using it