Click on the graph axis you want to change to a logarithmic scale. Note that by clicking on different parts of the chart, you can select the whole chart, the plot area only, the legend or each axis.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab ...