The horizontal axis is set to the logarithmic scale. You can modify the range. For a better view, we have changed the minimum range of the horizontal axis to 400. How to Plot a Log-Log Graph in Excel STEP 1 – Insert a Chart in Excel Select the dataset with the headers. Go to the...
Check the Logarithmic scale and input 10 in the Base section. The desired output will display like the one below. Method 2 – Using the Context Menu to Establish Log Scale to Excel Chart Axis STEPS: Select the B4:C10 field. Go to the Insert tab and click Recommended Charts. The Insert ...
logBase Specifies the base of the logarithm when using logarithmic scales. majorGridlines Returns an object that represents the major gridlines for the specified axis. majorTickMark Specifies the type of major tick mark for the specified axis. See Excel.ChartAxisTickMark for details. majorTimeUnit...
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.","author":{"__ref":"User:user:1085077"},"isEscalated":null...
ChartPointsCollection ChartSeries ChartSeriesCollection ChartSeriesFormat ChartTitle ChartTitleFormat ChartTrendline ChartTrendlineCollection ChartTrendlineFormat ChartTrendlineLabel ChartTrendlineLabelFormat CheckboxCellControl ColorScaleConditionalFormat ColumnProperties ...
Here is the same chart, with the scale transformed to a logarithmic scale, using the default base 10. Same as Excel 2003. Here the log scale has been changed to base 2. In 2007 we can change the min and max of the log axis to values other than 10 (i.e., other than the base)...
A logarithmic scale uses base 10 logarithms. Example This example sets the value axis on Chart1 to use a logarithmic scale. VB Charts("Chart1").Axes(xlValue).ScaleType = xlScaleLogarithmic Support and feedback Have questions or feedback about Office VBA or this documentation? Please seeOffice...
How to Make Log Scale in Excel. Microsoft's Excel spreadsheet program includes a Chart Wizard for making a variety of graphs from tabulated data. In some situations, as with scientific experiments, the data in one or both axes of the X-Y scatter graph co
Logarithmic trendline Moving average Error bars Chart basics Dynamic chart Dynamic chart(2) Slicers - Filter chart data Resize a chart Align chart to cell grid Group chart categories Lines between columns Custom charts Arrow chart Excel Chart Techniques Graph an equation Comparison table/chart Heat ...
3. Change the Chart Type toScatter Chart Change X Axis to Logarithmic SelectCustomize ClickHorizontal Axis CheckLog Scale Change X Axis to Logarithmic SelectCustomize ClickVertical Axis CheckLog Scale Keep in mind you can adjust the Scale Factor for the X and Y Axis ...