Not sure that is entirely true - I let the bottom scale be 1 on the log plots, zeros are not plotted (seen as gaps in the line); the linear plots all show the zeros.
View attachment 137596
Just to be clear - I wasn't criticizing you - I just detest the mess that Excel makes of trying to be a data analysis program.
In any case, the problem with gaps in a line plot, and with a line plot in general, is that it implies that the data are interpolatable, which is not the case for a histogram. As mentioned above, there is no continuous relationship between the data on the two axes.