The answer is to use a semi-log plot ... same scale on a graph. But you don't have to actually take the log of the data. There is another option—use a non-linear vertical axis.

When you create a graph in Excel, the software automatically sizes the X and Y axis lines, so the data you want to display is shown. You can override the settings and set the vertical and ...