Leave a Reply

    Your email address will not be published.

    How Many Decimal Places Are Helpful?

    Updated on: Sep 22nd, 2015
    Data Visualization
    , ,
    Collage of clipboard, clock, people, calendar and calculator.

    How many decimal places does your graph actually need?

    2, 1 or 0 decimal places?

    Most of my projects are in the social sciences. Social science measurement is not exact. We’re often creating instruments and tools from scratch to gather information. There are no rulers, tape measures, thermometers, or fancy gadgets guaranteed to give us exact numbers with exact certainty.

    Furthermore, I’m often involved in the data collection process. We’re always going to be missing a few surveys. We’re always going to need to estimate a few numbers. That’s how data collection works in the real world.

    I would never recommend that someone make a decision based on two decimal places.

    Should Country A be awarded more funding because they reached 89.34% versus 89%?

    Should Country B’s intervention program get revised because they reached 49.71% versus 50%?

    Does it really matter that Country C reached 25.07%? Can’t we simply round down to 25%?

    The last thing I want to do is give decision-makers a false sense of precision.

    Line graph with data labels that have two decimal points each.
    In real world datasets, I rarely show any decimal places.

    This revised graph would score well on the graph has appropriate level of precision section of the Data Visualization Checklist.
    Line graph with data labels that have no decimal points.

    Ready to revise your own graphs?

    Do not manually round your numbers up or down. You’re bound to make a rounding error or typo. Or worse, you’ll probably want to bang your head against the wall! Rounding by hand is tedious and completely unnecessary.

    Instead, use the Add Decimal and Decrease Decimal buttons on your Home tab to automatically adjust the number of decimal places that are displayed. Since your data table is linked to your graph, the graph will get instantly adjusted.

    The raw numbers – like that 9.84% – are still there. They’re not lost forever. They’re simply hidden from view.

    Screenshot of Excel spreadsheet showing how to let Excel round up or down decimal points while hiding original number.

    Are there instances in which you’d intentionally keep 1 or 2 decimal places in your graphs? Share your opinion below.

    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.


      Leave a Reply

      Your email address will not be published.

      You Might Like

      Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.


      Using Dashboards to Make a Family Trivia Event Even Better

      Emily Ross took our Dashboard Design course and is sharing how she uses dashboards to make a family trivia event even better.

      More »

      Inside our flagship dataviz course, you’ll learn software-agnostic skills that can (and should!) be applied to every software program. You’ll customize graphs for your audience, go beyond bar charts, and use accessible colors and text.



      Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.