Graph format: primary and secondary axis not congruent for the x axis

Hi,

I'm trying to create a graph with 4 data series. Two of which are in a scatterplot and two of which are in column format. The two sets of data are separated by each having a different y axis. However, the x axis for both graphs should be the same (time). Unfortunately when I switch two of the series to the different chart type (scatter to column), the x axis alignment is off.

The x axis coincides with the original two series in scatterplot format but the columns are no longer aligned with the x axis that's displayed. When I scroll over a column, the date it displays does not coincide with what the x axis is telling me. How do I make them congruent?

Thanks for your help! I've been banging my head against this for weeks.
\1

fourseries_twoaxes.xls

here's the workbook. Thanks for the help!

Thanks! That worked. I figured that I would need to trick excel into displaying it correctly.