Zeros on a logarithmic scale

Posted on 2012-08-21
Last Modified: 2012-09-05
By definition zeros cannot be represented on a logarithmic scale.  So, a log graph which contains zeros is problematic.  Is there a way to get Excel to ignore these values and stop giving persistent error messages?
Question by:karaflanagan
    LVL 15

    Accepted Solution

    You can add an IF inside your formula:

    Something like

    =if(a1=0, 'No zeros on logaritm', log(a1))

    Hope it helps

    Author Comment


    Thanks for the suggestion, but where would I add the formula as I am building the chart to make it ignore the zeros?
    LVL 15

    Expert Comment

    if you want to ignore, I think you should force an error value, such as an empty string. Put the if inside the formula you have and see what happens in graph.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now