Overview

In this lesson we will get to know some of the most common charts and how we can make them prettier.

Bar graph

With the help of bar graphs comparisons between individual groups of values ​​can be created quickly (quantitatively).

Screenshot 2015-03-31 21.10.22

In doing so, the orientation of the charts can create a clean representation even in long legends.

Screenshot 2015-03-31 21.17.15

Combined bar/line graph

This form of visualizations is properly suited for visualizing moving data with different units.

Screenshot 2015-03-31 21.10.34It is important to use the second axis to, for example, prevent the vanishing of the percentage display.

Screenshot 2015-03-31 21.20.45

The “position” of the formula moves to the “right” side. for more complex visualizations it is practicable to calculate the MIN and MAX values using the formula.

Line graph

Especially suited for visualizing trends and fluctuations over time.

Screenshot 2015-03-31 21.10.47

Particularly interesting is the possibility to present in thresholds.

Screenshot 2015-03-31 21.24.33

To choose how the threshold should start, select from the Drop-down next to the option “line”.

Distribution and shares

Now the pie charts, block graphs, area diagrams and mekko-diagrams come in hand.

Screenshot 2015-03-31 21.11.08

The special feature of area diagrams is that they are disguised as “line graphs”.

Screenshot 2015-03-31 21.29.53

Absolute value with origin information

Depending on the requirements, “waterfall diagrams” or “pile diagrams” could be useful.

Screenshot 2015-03-31 21.11.25

For the waterfall diagram, the detail settings of the formula must be entered.

Screenshot 2015-03-31 21.33.31

Trends – candle diagram

Particularly popular visualization of, for example, stock prizes.

Screenshot 2015-03-31 21.11.51

The following values have to be obtainable:

  • Upper
  • Top
  • Middle
  • Bottom
  • Lower

The information of where you entered and where you left has to be delivered because a coloured signal is set here.

Screenshot 2015-03-31 21.37.37

Relationship between data points

The “bubble-diagram” is particularly popular.

Screenshot 2015-03-31 21.12.19

Depending on 3 factors, a distribution can be made. For example:

  • Quantity
  • Sales
  • Contribution margin

The contribution margin gets visualized as an “area”.

Exercises

  • Build a diagram of choice
  • Give the characteristic settings a detailed look
  • Set the colour values to “hard”

Leave a Reply