HELP: Plotting 3 sets of different dates on same chart

Hi everyone,

I need to create a chart for work and am stuck on an issue w/ plotting dates. If anyone can help, I’d truly appreciate it. I’ve attached a copy of my document.

I have 3 different series: S, J, and D. Each series has a list of different dates, and I need to plot the results for each date, while comparing the 3 series. I have created 3 different charts to display the results for each series’ list of dates. However, I’d really like to chart all 3 series on one chart, so that you can see how the 3 compare. Does anyone know if that’s possible?

I believe my obstacle is that the list of dates are not consistent between the 3. I tried to get around this by creating one table with all the dates, and leaving blanks where necessary (on Sheet 2). However, this created a problem because the blanks showed on the charts as 0s.

Thank you in advance.

-L