Chart Skills for Data Analysis

 

1
Selected chart types based on stories

 

2
Fine-tuning Chart’s Elements

3
Deal with blank & hide Data in Chart
 
4
Highlight Negative Amount
 
5
Deal with Vertical Axes and Negative Amount

6
Show Average Line, and Auto Highlight Under Average Value

7
Show Total in stack Column Chart

 

8
Highlight Special Date or Time

9
Incell Chart – Sparkline
 
 
10
How to make your chart more interesting

11
know the lies in the charts    

‘Lies’ in Pie Charts

‘Lies’ in Line Charts

‘Lies’ in Column Charts