Peltier's technique uses the fact that we can have a date in the category axis (x-axis) of an area chart and Excel will plot them, even if they're not equidistant, like an x-y chart. He usees a secondary horizontal axis to plot hese on.
I've had a play with this and come up against a barrier when I try to convert a non-logarithmic date scale to a logarithmic one - can't.

All I can suggest at the moment is instead of plottting the raw x values, plot the log of the x values (calculated on the sheeet) and their corresponding date equivalents on non-logarithmic scales, You'll only have to do this for the x-axis values.

This messes up the x axis labels, which you could mask by overlaying a picture of the scale from a logarithmic plot!

I'll be working, on and off, trying to produce proof-of-concept charts, initially using Jon's example data and secondly on your data , so I can't give you a guess as to when I'll have done this, so I posted in the interim since you might be able to do it yourself in the meantime.