Home Business Intelligence How To Select the Greatest Chart Sort To Visualize Your Information

How To Select the Greatest Chart Sort To Visualize Your Information

How To Select the Greatest Chart Sort To Visualize Your Information


Cease constructing exhibitions of charts. Begin with the only most vital query and select one of the best chart kind on your information and your customers.

Charts, visualizations, or insights are the constructing blocks of all dashboards, so selecting the best chart kind is likely one of the essential abilities when constructing a dashboard. Decide the mistaken one, and you may trigger confusion, misinterpretation of the info, or perhaps a mistaken enterprise choice with an enduring impression.

On this article, I want to share my expertise in designing real-life enterprise dashboards and different data-heavy purposes, specializing in chart sorts.

Within the earlier publish about constructing dashboards customers really love to make use of, I talked in regards to the basic rules of constructing a dashboard. On this one, I’ll give attention to the main points of the dashboard’s constructing blocks, the charts. And also you higher know your charts properly earlier than constructing the dashboard. So let’s get began.

Begin with the use case — ask crucial query first

I might simply listing all obtainable chart sorts right here like in each different article on the web, however I feel this method results in pondering chart-first and creating already talked about exhibitions of charts. And also you don’t need to construct an exhibition. You need to ship a message together with your charts and dashboards — to have an effect in your customers. Hold that in thoughts everytime you really feel the urge to make use of the random however nice-looking chart you simply noticed in some infographics!

When deciding which chart to make use of, you must at all times begin with crucial query:

What do I need to present to my customers?

  • Present one huge quantity
  • Examine values inside and between teams
  • Present the relative composition of information
  • Show change over time
  • Clarify the connection between metrics
  • Plot geographical information
  • Present the main points of many gadgets

These seven use instances will cowl 99% of your information visualization wants. In case you reply the query with a use-case, which means with what you need to ship as a message, and never straight with the chart kind, you’re on the fitting path. Let’s now dive deeper into the main points.

What do I want to show to my users? The answer to this question dictates the chart type.
What do I need to present to my customers? The reply to this query dictates the chart kind.

Present one huge quantity with a KPI

Simply because you may have numbers, there may be not essentially a purpose to create a chart. Displaying a KPI (key efficiency indicator) is an effective way to convey headline determine info, whether or not you construct a advertising, venture administration, or provide chain dashboard. Good examples of KPI-worthy numbers are the next metrics:

  • Variety of bought gadgets
  • Gross income, internet income
  • Variety of guests to a web site

There are two crucial items of knowledge that should come together with a KPI.

First is the associated date vary or timeframe — which means the time span represented by the KPI. Sometimes within the type of a date filter on the dashboard or indicated within the title of the KPI.

The second is context. Displaying the quantity alone shouldn’t be sufficient. It’s worthwhile to give it context. For instance, to point out the distinction from the earlier interval or evaluate it with one other metric. With out context, the consumer can not inform if the quantity ought to make them smile or frown.

KPIs are best when showing the metrics as one big number.
KPIs are finest when exhibiting the metrics as one huge quantity.

Examine values inside and between teams utilizing a bar chart, column chart, or bullet chart

  • What’s the inhabitants in European nations?
  • What are my gross sales numbers in these nations?
  • Who’re the highest salespersons in my firm?

All these questions might be answered by essentially the most well-known and used kinds of charts — bar charts and column charts. These names are generally used interchangeably, however sometimes the columns are vertical, and the bars are horizontal (to recollect the path — image all these historic roman buildings with columns). The which means stays the identical — the size of the bar (or column) represents the worth. Don’t draw back from utilizing bar and column charts. They is likely to be omnipresent and well-known by customers however that’s their largest energy — they convey the message in essentially the most comprehensible approach.

Bar chart and column chart works well for comparing values within categories.
Bar chart and column chart works properly for evaluating values inside classes.

Each bars and columns in your charts might be grouped (generally referred to as clustered). For instance, if you wish to present the comparability not simply between the nations but additionally inside nations, the grouped bar chart is an efficient choice to point out, e.g., the typical age in nations (group) but additionally between women and men.

Another choice is to stack (or phase) bars in your chart. This step subdivides the info in every class, which means the chart can reply questions like what the gross sales are in several areas and throughout a number of product classes. The bars within the stacked bar chart generally is a easy sum of values to point out the entire, or all bars might be stacked to 100% to point out the share of every class.

Grouped column chart, stacked bar chart, and 100% stacked column chart.
Grouped column chart, stacked bar chart, and 100% stacked column chart.

You may have to go one step additional past easy comparability. For instance:

  • Who’re the highest salespersons in my firm, and what are their targets?
  • How is that this particular person doing compared to an organization benchmark?

bullet chart is an effective way to show solutions to such questions. The principle bar shows the present worth, the secondary bar can present, for instance, a earlier interval worth, and the image marker sometimes signifies a aim or benchmark worth.

Bullet chart packs a lot of information into an easy-to-understand form.
Bullet chart packs numerous info into an easy-to-understand kind.

Present the relative composition of information using a pie chart, donut chart, or treemap

Anytime you could present a easy composition or part-to-whole (how the share pertains to the entire quantity), this class of charts turns out to be useful. For instance:

  • Allocation of men and women amongst your prospects
  • Accepted and denied purposes for a college
  • Share of 1 area’s gross sales on the entire firm gross sales

These sorts of questions may very well be very properly answered by a pie chart or donut chart. Then again, pie and donut charts ought to come coated in black and yellow warning indicators saying don’t use for greater than two or three classes! People are merely terrible at evaluating angular distances — the sizes of slices — if there are too a lot of them. So for details about extra sophisticated compositions, learn on.

Pie chart and donut chart works well with two or three categories.
Pie chart and donut chart works properly with two or three classes.

Think about you need to show a composition of a two-level hierarchy. For instance:

  • Variety of people per continent and nation
  • Funds of various advertising marketing campaign classes and particular campaigns

This composition might be very properly proven by a treemap, which is principally an oblong pie chart. However because it’s rectangular, the realm is less complicated to understand by the human mind.

Treemap is great for displaying two levels of more complicated compositions.
Treemap is nice for displaying two ranges of extra sophisticated compositions.

Show change over time with a line chart, space chart, or column chart

Displaying the evolution of any metric over time is likely one of the most typical use instances whereas designing a dashboard. Just a few examples is likely to be:

  • Gross sales development over the previous 12 months
  • Variety of webpage guests development
  • Quantity of assist tickets coming to your assist desk day-to-day

All these use instances have in widespread that they present the progress of a metric in time. The change from one interval to a different is the important thing message communicated by these charts.

line chartspace chart, and column chart are the commonest chart sorts used to visualise change over time. Normally, they can be utilized interchangeably, however there are refined variations between them. Line charts and space charts are one of the best instruments to visualise information that goes up and down from each day. For instance, the variety of tickets in your backlog, the amount of cash in a checking account, or the temperature. Then again, column charts are your best option for information that begins at zero each interval. Just like the every day variety of assist tickets, month-to-month gross sales numbers, or webpage guests.

Line chart, area chart and column chart are the default option to show progress over time.
Line chart, space chart and column chart are the default choice to point out progress over time.

Now think about you need to show a gross sales development of your 4 completely different product classes. What’s the key message right here? Do you need to evaluate them in opposition to one another or present their share of the general gross sales efficiency? The previous is finest completed with a line chart with a number of strains, the latter with a stacked space chart.

Multi-line chart and stacked area chart can show the more complicated change over time.
Multi-line chart and stacked space chart can present the extra sophisticated change over time.

One final instance of displaying time, though on a cyclical foundation, is the most well-liked hours, days, or months. For instance, what are the busiest hours in your hotline through the week? Heatmap is a incredible kind of visualization for precisely this use case.

Heatmap showing the most popular days and times.
Heatmap exhibiting the most well-liked days and instances.

Clarify the connection between metrics with a scatter plot, bubble chart, or combo chart

Explaining a relationship or correlation between two metrics might be very helpful because it’s one step additional in the direction of getting priceless insights from the info. In case you ever have to reply a query like the next examples, the scatter plot is your best option:

  • How does the marketing campaign spend relate to its income throughout many alternative campaigns?
  • What’s the relationship between the variety of orders and whole income by the product class?
  • What number of programs every pupil began and completed?

Every marketing campaign, product class, or pupil is represented by the dot on the chart, and every metric is then encoded on one of many X and Y axes.

Scatter plot showing the relationship between two metrics.
Scatter plot exhibiting the connection between two metrics.

Including a 3rd metric to the combo brings an additional degree of perception but additionally an additional degree of complexity. This extra metric is often represented by the scale or the colour of the dot, which then turns into a bubble, subsequently a bubble chart. Just a few instance questions that may be answered with bubble charts are:

  • What number of programs did every pupil begin and end (X and Y axis) and what college did they research at (bubble shade)?
  • What’s the relationship of the corporate’s whole income in every nation (bubble measurement) to the variety of shops in that nation (Y-axis) and to the variety of staff in that nation (X-axis)?
  • Or some of the well-known bubble charts by Hans Rosling — how do the nation’s GDP per capita (X-axis) and inhabitants (bubble measurement) relate to life expectancy (Y-axis)?
Bubble chart can show even more complicated relationships well.
Bubble chart can present much more sophisticated relationships properly.

A relationship or correlation between two metrics may also be proven over time. For instance, the variety of guests and the income of the e-commerce web site. In that case, a combo chart consisting of a column chart and the road chart comes into play. With two unbiased Y axes, it’s attainable to point out the connection even between metrics with vastly completely different scales.

Combo chart is the best option when the two comparable metrics have very different scales.
Combo chart is the best choice when the 2 comparable metrics have very completely different scales.

Plot geographical information on the map

At any time when you could show geographical information, it’s type of apparent to place them on a map. For instance:

  • Distribution of shoppers throughout states
  • Variety of individuals residing within the cities
  • Income per area

The placement is a typically understood idea, and a map supplies a direct connection to the info. Then again, having geographical information doesn’t imply the map is the best choice. For instance, if you could show a relationship between two completely different metrics for a single geographic location, e.g. the variety of shops in a state and the typical gross sales for that state, it’s higher to return to scatter of bubble charts than attempt to cram an excessive amount of info on the map.

There are two fundamental methods to show information on a map. To fill the realm (e.g. a state) or to make use of a pushpin or different form over the goal space. Normally, I might recommend utilizing the pushpin on the map over the stuffed areas (a stuffed map is typically referred to as a choropleth). Why? As a result of the scale is psychologically perceived as a a lot stronger indicator than the colour shade. Subsequently the poorly performing giant states (let’s say Alaska) will overshadow many better-performing small states (for instance, Massachusetts). In different phrases, geographic significance doesn’t translate to information worth significance.

Additionally make sure you use the map solely as a background, the star of the present are the info factors.

Map is the generally understood tool to show the location.
Map is the commonly understood instrument to point out the situation.

Present the main points of many gadgets as a great previous desk

Sure, though they won’t be essentially the most hanging type of visualization, tables have their place on the dashboards in some instances. The truth that you may have information to point out doesn’t imply they must be proven as a chart. Generally one of the best form for the info continues to be the common-or-garden desk.

The desk must make sense within the context of the entire dashboard, although. For instance, a dashboard targeted on orders from the e-commerce retailer, exhibiting varied overviews and abstract charts, and in the long run, it might present all of the separate orders in a desk. So you possibly can see the order particulars and even drill from the dashboard straight into your system to see all the main points of that individual order. Different examples may very well be:

  • Merchandise particulars — product class, gadgets bought, common worth, % of income
  • Clients particulars — identify, e mail, # of orders, whole income
  • Help brokers — identify, place, # of assigned tickets, # of resolved tickets, CSAT

Generally, if you could listing particulars of a bunch of things, the desk is often a good selection. Particularly if it’s a part of the dashboard, it’s interactive and permits customers to type columns, drill into different dashboards, and so on.

Lastly, having no less than one desk on the dashboards might additionally function a negotiation trick for the extra cussed stakeholders who should not prepared to depart their protected and acquainted house of Excel.

Table can show the more complicated data with a lot of details.
Desk can present the extra sophisticated information with numerous particulars.

Keep boring, keep away from unique chart sorts

So the opposite day, you went on the web and located some thrilling visualization to spice issues up slightly in your dashboard. One thing like you will discover within the Xenographics zoo of information visualizations. Nicely, overlook about it. A few of these charts may look cool on some fancy infographics however not in your typical dashboard. Once more, the dashboard is about understandability. Be slightly boring with the chart sorts on function. The customers of your dashboards will thanks.

Abstract of the important thing rules

We’ve explored the 99% of the commonest use instances of information visualization you possibly can come throughout and likewise essentially the most helpful chart sorts. The visible a part of the info presentation is basically vital however at all times remember the fact that the main target ought to lay on following the use case and delivering the message to your viewers. Adhere to the talked about rules, and you may’t go too mistaken.

  • Begin with the use case
  • Present one huge quantity with a KPI
  • Examine values inside and between teams utilizing a bar chart, column chart, or bullet chart
  • Present the composition of information using a pie chart, donut chart, or treemap
  • Show change over time with a line chart, space chart, or column chart
  • Clarify the connection between metrics with a scatter plot, bubble chart, or combo chart
  • Plot geographical information on the map
  • Present the main points of many gadgets as a great previous desk
  • Keep boring, keep away from unique chart sorts

Don’t construct exhibitions of charts. Construct usable and comprehensible dashboards as a substitute!

If you wish to strive any of the talked about charts, you possibly can register for the GoodData trial and play with them by yourself. Or, alternatively, request a demo and we’ll stroll you thru them.



Please enter your comment!
Please enter your name here