Logarthemic Axis

Excel

Monthwise Pie Chart

VBA

Listbox Option Button

Chart Styles

Spark Lines

Color of Points

Charts with Check Boxes

Classification Of Charts

Histogram Chart

Excel- Charts Introduction

Types of Charts

Dynamic Chart Creation

Combination Chart

Bottom To Top

If Function - Dropdown

Format Axis Not Required

Listbox-Optionbutton

Conditonal Formatting

Chart With Tabluar Data

Scroll Bar Chart

Option Button Chart

From Top To Bottom

Matching Text TopToBottom

Hidden or Empty Cells

Explain about the LOGARITHMIC AXIS?

Logarithmic charts are very useful when we need to chart SMALL and LARGE values

We can observe how Log scale is useful based on below mentioned table

If we charted below mentioned table with actual scale, here is the output

There is abnormal variation between SMALL number of LARGE number

If we observe the chart, small values less than 1000 not displaying on chart.

Because Application by default considered 1000 as Minimum value.

From the year 1999 onwards values are displaying on chart

Features of LOGARITHMIC AXIS

By default excel determines Min and Max values
Log scale is useful when we have huge variation between Min and Max values
Log scale is not useful for negative or zero values(<=0)
Default value for LOG scale is 10

Here is the LOG scale value calculation procedure:

Steps to follow to create log scale:

Select vertical axis scale
Right Click on scale
select the option of Format Axis

Change the scale value and click on close

Now LOG scale has been plotted on vertical axis of chart

Log Scale Chart:

Now we can find all the year's data on chart