In their new book ‘Making Numbers Count,’ co-authors Chip Heath and Karla Starr explain that our brains have not evolved to easily understand large numbers.
We really only have an instinct for small quantities – as in, five and fewer.
Beyond that, it’s just some vague notion of “lots.”
Data visualizations serve to transform and compare large amounts of data, but most reporting dashboards today are still like 1990s websites.
We put up with them, but they’re ugly and awful, and we wouldn’t trust them with our credit cards.
Non-strategic reports – dashboards that are too cluttered or too sparse to comprehend – make it harder for your clients and stakeholders to understand the data and take smart action.
Here’s how to turn those clunky dashboards into useful analysis.
1. Get Rid Of Charts That Have No Purpose
Not every chart in your dashboard deserves to be there.
Unnecessary charts distract and compete for attention with graphs that do matter.
They can also derail meetings, encouraging your client to focus on minutia and natural variance rather than the essential.
Not all data breakouts are useful. Some are just useless, and some are anti-useful.
Make each chart earn its place in the dashboard by removing everything that doesn’t:
- Tie back to objectives.
- Provide context.
- Aid comprehension.
2. Get Rid Of “Unnecessary Ink”
Statistician and dataviz pioneer Edward Tufte explains,
“…clutter and confusion are failures of design, not attributes of information.”
Tufte introduced the “data-ink ratio,” which tells us to strip all decorative or extra “ink” from charts until we’re left with only the essential.
Improve your data-ink ratio by minimizing or removing:
- Any bevel or 3D effects.
- Redundant chart legends.
- Chart borders and shadows.
- Background color fills.
Tables are inherently busy, showing a lot of data all at once.
To make your tables easier to read:
- Remove pagination and row numbers.
- Use compacted numbers (12M instead of 12,000,000).
- Remove truncation (“…”) by expanding the column width or wrapping text.
- Remove decimals (when numbers are >1).
When you introduce white space and eliminate chartjunk, your reports tell a clearer story.
3. Fix Misleading Axes
Sometimes charts are so intentionally misleading that they end up making headlines.
More often, though, charts that mislead do so unintentionally.
Here’s how to find and fix common data visualization mistakes.
One common mistake is using a “truncated graph,” where the y-axis doesn’t start at 0.
Truncated graphs are so common that Google Data Studio uses them by default in some of its chart options.
The fix for this is easy.
Just set any “axis minimums” from auto to zero.
While less common, charts can sometimes have an inappropriate maximum.
This can happen when you’ve hardcoded the max axis based on a previous data set, and you forget to update it when it’s using a different data range.
Also a very easy fix.
Another issue is using a “logarithmic scale” for your charts.
When you’ve tried to get a chart to look a certain way and nothing else worked, you may have switched over to log scale for better visualization.
Unless you’re truly working with logarithmic data though, that’s not okay.
Change it back to linear.
4. Fix Poor Chart Selection
Chart selection is not as easy as just changing an axis. But it’s arguably more important, and easier to get wrong.
Have you ever tried to use a chart selection guide, only to be asked whether your data is nominal or categorical?
If you’re not fluent in data visualization, then it can feel easier to just stick with trial and error until you land on something that looks okay.
Marketer’s Crash Course In Chart Selection
This is not a complete guide, but it covers a lot of dashboard mistakes:
- Use scorecards for your big KPIs, even if the same data is in tables and other graphs in the report. It emphasizes what’s most important.
- Use line charts to show trends over time. If your x-axis is anything other than a time series (continuous data), don’t use a line chart.
- Only use pie/donut charts to show the composition of a whole, ideally with five or fewer categories. Need to compare pie charts to each other to show a change in composition? You probably need a different chart type. A stacked bar chart could be a good choice.
- Map charts are a good way to visualize data across regions, and clients seem to like them. Be sure that you’re not just mapping population data though, which is generally not helpful in making business decisions.
- Bar charts work well to compare category performance for a single metric. Think sales driven by (campaign, landing page, etc).
5. Add Contrast
Removing “unnecessary ink” from your charts puts you on the right track.
This next step is to layer on “necessary ink” that focuses your reader’s attention and makes your chart even easier to interpret.
These three charts all use an identical data set:
Chart A has no focus and feels “noisy.”
Charts B and C vary line thickness and color to draw your attention to a single line.
Even though you don’t know the actual metrics or dimensions in Charts B and C, you immediately know where to focus.
This is an example of using “pre-attentive attributes,” which our brains process instantly on a subconscious level.
When you want to emphasize a key point, you can increase contrast with preattentive attributes like:
Don’t leave your audience asking “what am I looking at?”
Help them out with contrast and preattentive attributes.
6. Add Context
Context is another type of “necessary ink” that clarifies the meaning of your visualizations.
As a marketer and subject matter expert, you know what your charts are about.
You can survey all your dashboards and quickly identify trends and outliers.
For your clients and stakeholders, that’s probably not the case.
The people on the receiving end of your reports are likely not intimately familiar with the acronyms and shorthand that’s obvious to you.
They need more context in the form of:
- Chart titles and descriptions.
- Acronyms that are spelled out and defined.
- Annotations and microcopy.
Your audience also needs a better understanding of the factors driving the trends and data changes in the report.
The metric is the “effect,” but what is the “cause”?
Look beyond the metrics themselves to find the narrative.
- What are the internal and external forces that contribute to performance?
- What backstory might they be missing (historical, seasonality, competition, buyer preference)?
- Given current and projected trends, what needs to happen next?
Finally, don’t assume that your audience knows the targets, even if they were the ones who set them.
Help them out by comparing performance to goals and not just previous time periods.
‘Presentation Zen’ author Garr Reynolds said,
“…you can achieve simplicity in the design of effective charts, graphs and tables by remembering three fundamental principles: restrain, reduce, emphasize.”
Remove what is unnecessary, fix remaining problems, and add context and meaning to make your charts and dashboards as powerful as possible.
Featured Image: Saklakova/Shutterstock
Google’s Helpful Content & Core Updates [Webinar]
Google recently rolled out a new core update and the Helpful Content update. But what does that mean for your business?
How can you tweak your content and SEO strategies so that they properly align with the latest algorithm changes?
With Google now prioritizing user experience, it’s important to publish content that’s helpful to humans and relevant to their search queries.
Though this update has challenged many companies and made the content creation process more complex, there are certainly ways your website can still thrive online.
The key is finding the right balance between search engine compliance and customer satisfaction.
Join me and Dave Snyder, CEO and Founder of CopyPress, as we discuss ways you can adjust your content production to improve search rankings and maximize results.
In this webinar, you’ll discover:
- How to create Helpful Content for Google.
- How to scale authority and build subject matter experts as part of your production cycle.
- Ways to recover if you’ve been dinged by Google.
You’ll learn how to create better content with authority that complies fully with Google’s revised Helpful Content guidelines.
Whether you have a small website or need to scale your content production, you’ll learn how you can create and implement a content strategy that keeps Google happy and fulfills your customers’ needs for compelling, helpful content.
By the end of this webinar, you’ll be equipped with all the information you need to adapt your content strategy for success on Google.
Can’t make the live session? Register now, and we’ll send you a recording after the event.
Let’s Sing ABBA: When Karaoke Meets Disco
Google’s Helpful Content & Core Updates [Webinar]
Rights holders got Google to remove 6 billion links from Search over 10 years
Google to pay $85 million to settle claims it deceptively tracked users
Instagram Tests Out New Ad Options, Including Explore Placement and Interactive AR Displays
Remaking Dead Space, Available for Pre-Order Today
Workforce Trends You Need To Know About in 2022 [New Data]
Offline Wednesday For Yom Kippur 5783
Which Is Better For You?
Expert shares advice for keeping children safe online
Explore the Path to Digital Future: Interconnect, Integrate and Innovate
Google Updates Documentation On Meta Descriptions
Daily Search Forum Recap: September 5, 2022
7 Tips For Creating Instagram Story Ads That Convert
How To Launch Your First Google Ads Remarketing Campaign
Microsoft Advertising Gains Pinterest Import, More Google Imports, & More
Google Again Says Spikes In Crawling Activity Not A Sign Of The Helpful Content Update Rollout
Daily Search Forum Recap: September 30, 2022
The Ultimate Timeline of Google Algorithm Updates (+ Recommendations)
Confusion Over Google Search Console’s HTTPS Is Invalid And Might Prevent It From Being Indexed