A Logarithmic stock chart would display both the move from 10 to 20 and 20 to 40, each as 100% gains from each other and each over a 1/4' spacing. It displays spacing in terms of percentage movements. Note the log scale is usually used for numbers that grow very large, rather than very small. – zeFrenchy Apr 15 '15 at 14:09 1 It'a math: ln(x).
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
To create a log-log graph in Microsoft Excel, you must first create anXY (scatter) graph. This is the only graph type that will work; othergraph types permit logarithmic scales only on the Y axis. To create alog-log graph, follow the steps below for your version of Excel.
Excel 2010 or 2007
- In your XY (scatter) graph, right-click the scale ofeach axis and select Format axis....
- In the
Format Axisbox, select the AxisOptions tab, and then check Logarithmic scale.
Logarithmic Chart Excel
Other versions of Excel
Logarithmic Charts In Numbers For Macs
- In your XY (scatter) graph, double-click the scale ofeach axis.
- In the
Format Axisbox, select the Scaletab, and then check Logarithmic scale.