Combination of bar and line chart with horizontal time axis

You can use formula to calculate positions. Although you will need to fixed the secondary horizontal axis.

You can not avoid using the secondary horizontal axis as there appears to be a bug that restricts the xy-scatter series to have the maximum number of points as categories on the primary horizontal axis.