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. On a linear scale, a line chart plotting these numbers would go insanely high very quickly. On a log scale, each of these amounts takes up the same space, because, in each year, the number of candies grows at a fixed rate (100%). How to read a log scaled chart. Let’s see what that means for our chart. With its impressive tables and images, Numbers makes it possible to create beautiful spreadsheets, and comes included with most Apple devices. Use Apple Pencil on your iPad to add useful diagrams and colorful illustrations. And with real-time collaboration, your team can work together, whether they’re on Mac, iPad, iPhone, or using a PC.

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

• The Numbers app for the iPad and iPhone was designed from the ground up as the ultimate spreadsheet tool for the mobile platform. I now prefer both the Excel mobile app and Google Sheets, so my work on new templates for Numbers has ended. I have also discontinued the Spreadsheet Templates app for iPad.
• . Use e for scientific notation. E.g: 5e3, 4e-8, 1.45e12. Then the base b logarithm of a number x: log b x = y. Logarithm change of base calculator.

1. In your XY (scatter) graph, right-click the scale ofeach axis and select Format axis....
2. In the Format Axis box, select the AxisOptions tab, and then check Logarithmic scale.

Logarithmic Chart Excel

Other versions of Excel

Logarithmic Chart Scale

1. In your XY (scatter) graph, double-click the scale ofeach axis.
2. In the Format Axis box, select the Scaletab, and then check Logarithmic scale.