# Lesson 10 – Standard data presentation ## 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). In doing so, the orientation of the charts can create a clean representation even in long legends. ## Combined bar/line graph

This form of visualizations is properly suited for visualizing moving data with different units. It is important to use the second axis to, for example, prevent the vanishing of the percentage display. 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. Particularly interesting is the possibility to present in thresholds. 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. The special feature of area diagrams is that they are disguised as “line graphs”. ## Absolute value with origin information

Depending on the requirements, “waterfall diagrams” or “pile diagrams” could be useful. For the waterfall diagram, the detail settings of the formula must be entered. ## Trends – candle diagram

Particularly popular visualization of, for example, stock prizes. 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. ## Relationship between data points

The “bubble-diagram” is particularly popular. 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”