Blog

datavizcatalogue: dataviz icons

"Book" tip: Interactive Dataviz lexicon

, ,
Data visualization in general means to bring abstract data and relationships into a visually comprehensible form. So far so good. But what are the unfamiliar forms of representation? When do I apply this? When are other forms more meaningful? I…
Template: mehrere Diagramme richtig skalieren

Portfolio Diagrams "reloaded"

Portfolio diagrams can be created with the Excel „bubble“ diagram modus for many applications.  What makes this type of diagram special is that a total of three data dimensions can be visualised: X-position (horizontal), Y-position (vertical)…
Template: mehrere Diagramme richtig skalieren

Small Multiples Are Quick and Easy

One of our previous posts discussed small multiples, i.e. a series of charts consisting of several small charts of the same type. It also describes conceptual considerations on typical application scenarios involving small multiples. This…
Template: mehrere Diagramme richtig skalieren

Clever Data Labels

Labelling data points in charts is generally more reader-friendly than using a vertical axis. The axis is automatically displayed in Excel, and therefore it is often found in reports and presentations. However, it forces the chart reader to…
Abweichungen im Dashboard

Small Multiples in Excel – Small But Good

"Small multiples" are charts that display a range of data in several smaller charts of the same type. This is often easier to read than mixing the same data in a single, more complex chart. The informational value and overview are the result…
Saeulendiagramm mit Doppelstapel

Use grouped piles in diagrams

In bar diagrams multiple streams of data can be grouped (side by side) or piled (on top of each other). Both display formats are important. Sometimes it is also practical to combine both forms. E.g. two piled columns side by side per month. Due…
Abweichungen im Excel Diagramm darstellen

Illustrate variations

It´s mostly about variations when presenting data to decision makers, such as planned, target or empirical values. Only these variations allow us to reasonably evaluate the actual numbers. Variations should play a major role during the visualisation…
Template: Diagramm direkt an den Säulen beschriften

Direct captioning of diagrams

Data captions and legends are important to understand the content of diagrams. Unfortunately the provided alternatives to caption are partially not legible. For example, sums on top of piled columns are not provided. You search in vain for…
Template: mehrere Diagramme richtig skalieren

Correct scaling of multiple diagrams

In many cases it is important to allocate data to multiple diagrams so the presentation is clear. It results in so-called Small-Multiple illustrations. If each single diagram uses its own scale, the informative value of the entire page will…