A log-log chart is a graph that uses logarithmic scales for both the x-axis and the y-axis. Logarithmic scales are useful for data that spans several orders of magnitude, such as data on population growth or the spread of a disease.
To create a log-log chart in Excel:
- Select the data that you want to plot.
- Click the Insert tab, and then click Scatter.
- Click Scatter with only Markers.
- Click OK.
- Right-click the x-axis, and then click Format Axis.
- Under Axis Type, click Logarithmic scale.
- Click OK.
- Right-click the y-axis, and then click Format Axis.
Under Axis Type, click Logarithmic scale.
Creating a
Log Log Chart in Excel
1) Select the data that you want to plot.
2) Click the Insert tab, and then click Scatter.
3) Click Scatter with only Markers.
4) Click OK.
Move beyond
Excel
Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.