Any steps you can suggest that make this simpler in the future would be most appreciated. I would have thought with two simple columns of data, I could click two or three times and the basic chart would have been there, complete with date labels along the x-axis and $ labels along the y-axis.

I am surprised at how complicated this ended up being. finally, I spent a long time with the layout and format buttons to get my labels to turn out right, and my columns to be the right color. clicked on 'switch row/column', as you suggested, and this time it made a bit more sense (even though one side is called 'series' and the other is called 'row') and got my bars lined up the way I wanted. inserted simple pivot table with the year as the row labels and the $ as the amount (no column) This is an indication that the two variables do indeed have a power law relationship.Marvin, I appreciate your difficulty! As it turns out, I did figure it out. Also notice how the relationship between the variables x and y now appears more linear. 3) And, as CK 76 mentioned, you can also look outside Excel for this, since there are other charting engines that have built in support for 3D scatter charts. Notice that the x-axis now spans from 1 to 10 while the y-axis spans from 1 to 1,000. Plot y vs x at different values/groups for z or z vs y at different values/groups for x or however you want. Next, click on the y-axis and repeat the same step to change the y-axis scale to logarithmic. Step 3: Change the y-axis scale to logarithmic. In the new window that pops up, check the box next to Logarithmic scale to change the x-axis scale. Right click on the values along the x-axis and click Format Axis. Step 2: Change the x-axis scale to logarithmic. The following scatterplot will automatically appear: Within the Charts group, click on Scatter. Use the following steps to create a log-log plot for this dataset:Īlong the top ribbon, click the Insert tab. Suppose we have the following dataset in Excel that shows the values for two variables, x and y: This tutorial shows how to create a log-log plot for two variables in Excel.

This phenomenon occurs in many fields in real life including astronomy, biology, chemistry, and physics. This type of plot is useful for visualizing two variables when the true relationship between them follows a power law. A log-log plot is a scatterplot that uses logarithmic scales on both the x-axis and the y-axis.

How to plot a graph in excel x vs y