In this lesson we will get to know some of the most common charts and how we can make them prettier.
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.
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.
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:
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:
- Contribution margin
The contribution margin gets visualized as an “area”.
- Build a diagram of choice
- Give the characteristic settings a detailed look
- Set the colour values to “hard”