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
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
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
last/sum as a line
put it on top
How to insert a bubble chart?
insert bubble chart
size of bubbles in dependency
labels for bubbles
How to use and create a gantt chart?
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