May 15 2020 06:42 AM
Jul 26 2021 07:43 AM
I hope it will help.
To tell Excel that you want to use logarithmic scaling of the value access, follow these steps:
Right-click the value (Y) axis and then choose the Format Axis command from the shortcut menu that appears.
When the Format Axis dialog box appears, select the Axis Options entry from the list box.
To tell Excel to use logarithmic scaling of the value (Y) axis, simply select the Logarithmic Scale check box and then click OK.
Excel re-scales the value axis of your chart to use logarithmic scaling. Note that initially Excel uses base 10 logarithmic scaling. But you can change the scaling by entering some other value into the Logarithmic Scale Base box.