What is the success formula for visual presentations?
SAY: convey a message
UNIFY: apply sematic notation
CONDENSE: increase information density
CHECK: ensure visual integrity
EXPRESS: choose proper visualization
SIMPLIFY: avoid clutter
STRUCTURE: organize content
What to do in presentations?
Remove all unnessary stuff
Which colors do you use in diagrams?
black/grey: previous data
blue: actual/ planning data
How to colour the background of a diagram?
no fill for whole chart
Bars over columns
select columns and fill with color
mark whole chart and than white
How to insert a trend sign above the columns with colors?
no fill in background
select cell
reference to tablet
cell below: if (cell > 0; “ “; “ “) -> wingding3
conditional formating: by rule -> <>0
How to get sums of the top of a bar chart?
Mixed / combo diagram
Select all
last/sum as a line
put it on top
How to add the legend data on the side?
use cell on the side
mark everything and fill with white
How to have a picture in the background?
Right tap
fill
picture
insert picture
How to insert a picture as the Bars?
select bars
Format Data Series
picture source: stack
How to insert a bubble chart?
insert bubble chart
horizontal axis
vertical axis
size of bubbles in dependency
labels for bubbles
How to use and create a gantt chart?
stabled diagramm
start date and duration as stabeled
white colour for start date
set start to 0 by using numbers for the first date
change the position of the labels
reduce everything not useful
How to create a speedometer?
with a bar chart
calculate the goal target /2
move the lower 50% to the bottom with no color
change color and outliers
change background
change number description from 50% to the right
use text boxes
Last changed2 years ago