Blog

Abweichungen im Excel Diagramm darstellen

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 as well. Today´s trick shows us that this is feasible within Excel only with a few clicks in […]

Template: Diagramm direkt an den Säulen beschriften

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 standard functions such as legends which support the viewer not to look back and forth as they are […]

Template: mehrere Diagramme richtig skalieren

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 get lost. In terms of a high quality visualisation, unitary scales are very important. At the […]

    The origin of portfolios is in finance and describes a planning method of compiling a package of security papers (security holdings) dependent on to the criteria of return and risk. Later, this method has been applied to other areas in the 70ies. Since that time the portfolio analysis has been modified in many […]

Opinions, trends and behaviours – the interest in surveys is growing steadily. Numerous evaluation results are prepared and presented daily. Diverse ways of visualising the results are available, still some essential basics should be considered. Good to know: Survey results are most interesting when the reader can quickly draw comparisons. When executing the primary demands, […]

Im letzten Blogartikel habe ich es angekündigt. Hier also mein Eindruck der druckfrischen Ausgabe von Stephen Fews neuem Buch: „Bessere Entscheidungen können nur durch besseres Verständnis kommen. Informationstechnologien sind nicht der Schlüssel zu besseren Entscheidungen, das sind wir. Technologien können unser Denken erweitern, aber nicht ersetzen. Computer haben ein neues „Datenzeitalter“ eingeläutet. Das „Informationszeitalter“ wird erst […]

What are Bullet Graphs and where are they used? Key data overviews on dashboards are easier to understand by visualisation. The realisation is quite difficult, because standardised diagrams are uneligible for this function. Bullet Graphs, a special type of bar diagrams, have been especially developed by Stephen Few. Basically they are very suitable for  those […]

Ein kleiner Projekt-Einblick in ein übersichtlich aufgebautes Sales Dashboard. Durch die Realisierung in Excel, ohne etwaige Plugins oder VBA-Programmierung, lässt es sich komplikationslos von jedem Office-Anwender nutzen und verteilen. Die Datenaufbereitung basiert in diesem Beispiel auf Pivot-Tabellen. Eine Datenbank-Anbindung ist problemlos möglich. Das ist keine Zauberei oder ewige Tüftelei. Versprochen! Wenn Sie unsere Lösung interessiert, […]