Chart Skills for Business 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

12
Case: Product-Defect Rate 

13
Case: AFMA Event Attend Ratio   

14
Case: KPI for Each Department   

15
Case: Sales YOY Growth% for Each Product   

16
Case: YTD OPEX Budget Resource Usage   

17
Case: FTE Distribution in Departments 

18
Case: AFMA Customers’ Profile – Age Distribution

19
Case: AFMA Sales Amount in Each Month

20
Case: Sales Trend Analysis

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.