Excel defaults to a linear scale for graphs, but you can easily change it to logarithmic to suit ... Your Graph to the Same Scale on a Vertical & Horizontal Axis in Excel How to Make Your Graph ...

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

How to add a single vertical bar to a Microsoft Excel line chart ... the axis values to the right. In the Format Axis pane, change the Maximum Bounds value to 1,800,000. Next, expand the Labels ...