Daily Sales Dashboard in Excel
Daily Sales Dashboard in Excel
Daily Sales Dashboard in Excel
10000
8000
Monthly Sale
6000
4000
2000
0
100% 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3
19 19 19 20 20 20 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22
44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44
l
17 18 19 20 21 22 23 24 25 26 27 ta
42 442 442 442 442 442 442 442 442 442 442 To
d
an
Gr
Date # of Calls Sales Calendar Month
1-Jan 627 23000 1 January
2-Jan 530 6000 2 January
3-Jan 950 17000 3 January
4-Jan 821 19000 4 January
5-Jan 837 34000 5 January
6-Jan 627 5000 6 January
7-Jan 552 7 January
8-Jan 648 8 January
9-Jan 540 9 January
10-Jan 828 10 January
11-Jan 726 11 January
12-Jan 596 12 January
13-Jan 784 13 January
14-Jan 965 14 January
15-Jan 544 15 January
16-Jan 940 16 January
17-Jan 729 17 January
18-Jan 992 18 January
19-Jan 540 19 January
20-Jan 668 20 January
21-Jan 669 21 January
22-Jan 729 22 January
23-Jan 882 23 January
24-Jan 890 24 January
25-Jan 892 25 January
26-Jan 632 26 January
27-Jan 899 27 January
28-Jan 931 28 January
29-Jan 771 29 January
30-Jan 520 30 January
31-Jan 618 31 January
1-Feb 732 1 February
2-Feb 771 2 February
3-Feb 941 3 February
4-Feb 985 4 February
5-Feb 931 5 February
6-Feb 770 6 February
7-Feb 642 7 February
8-Feb 606 8 February
9-Feb 777 9 February
10-Feb 851 10 February
11-Feb 930 11 February
12-Feb 582 12 February
13-Feb 581 13 February
14-Feb 735 14 February
15-Feb 787 15 February
16-Feb 527 16 February
17-Feb 954 17 February
18-Feb 851 18 February
19-Feb 802 19 February
20-Feb 601 20 February
21-Feb 999 21 February
22-Feb 837 22 February
23-Feb 759 23 February
24-Feb 657 24 February
25-Feb 571 25 February
26-Feb 796 26 February
27-Feb 501 27 February
28-Feb 779 28 February
1-Mar 976 1 March
2-Mar 658 2 March
3-Mar 647 3 March
4-Mar 991 4 March
5-Mar 502 5 March
6-Mar 770 6 March
7-Mar 953 7 March
8-Mar 754 8 March
9-Mar 950 9 March
10-Mar 613 10 March
11-Mar 888 11 March
12-Mar 886 12 March
13-Mar 722 13 March
14-Mar 550 14 March
15-Mar 860 15 March
16-Mar 806 16 March
17-Mar 736 17 March
18-Mar 945 18 March
19-Mar 641 19 March
20-Mar 675 20 March
21-Mar 986 21 March
22-Mar 980 22 March
23-Mar 848 23 March
24-Mar 635 24 March
25-Mar 729 25 March
26-Mar 737 26 March
27-Mar 505 27 March
28-Mar 566 28 March
29-Mar 850 29 March
30-Mar 554 30 March
31-Mar 675 31 March
1-Apr 796 1 April
2-Apr 727 2 April
3-Apr 806 3 April
4-Apr 560 4 April
5-Apr 996 5 April
6-Apr 669 6 April
7-Apr 998 7 April
8-Apr 512 8 April
9-Apr 893 9 April
10-Apr 797 10 April
11-Apr 663 11 April
12-Apr 554 12 April
13-Apr 703 13 April
14-Apr 857 14 April
15-Apr 664 15 April
16-Apr 962 16 April
17-Apr 590 17 April
18-Apr 613 18 April
19-Apr 914 19 April
20-Apr 549 20 April
21-Apr 516 21 April
22-Apr 803 22 April
23-Apr 802 23 April
24-Apr 986 24 April
25-Apr 568 25 April
26-Apr 638 26 April
27-Apr 712 27 April
28-Apr 789 28 April
29-Apr 820 29 April
30-Apr 569 30 April
1-May 897 1 May
2-May 527 2 May
3-May 798 3 May
4-May 695 4 May
5-May 871 5 May
6-May 660 6 May
7-May 818 7 May
8-May 946 8 May
9-May 570 9 May
10-May 666 10 May
11-May 778 11 May
12-May 718 12 May
13-May 566 13 May
14-May 940 14 May
15-May 646 15 May
16-May 667 16 May
17-May 912 17 May
18-May 624 18 May
19-May 658 19 May
20-May 616 20 May
21-May 934 21 May
22-May 897 22 May
23-May 791 23 May
24-May 737 24 May
25-May 891 25 May
26-May 805 26 May
27-May 675 27 May
28-May 959 28 May
29-May 553 29 May
30-May 855 30 May
31-May 580 31 May
Month January Month January
# of Calls Sales Sales Conversion Average Sales Per day Row Labels Sales
22877 9804 42.9% 316 1-Jan 279
2-Jan 179
3-Jan 287
4-Jan 406
5-Jan 317
6-Jan 181
7-Jan 491
8-Jan 300
9-Jan 420
10-Jan 461
11-Jan 337
12-Jan 206
13-Jan 192
14-Jan 225
15-Jan 486
16-Jan 368
17-Jan 138
18-Jan 343
19-Jan 382
20-Jan 275
21-Jan 448
22-Jan 169
23-Jan 348
24-Jan 405
25-Jan 139
26-Jan 474
27-Jan 180
28-Jan 280
29-Jan 444
30-Jan 168
31-Jan 476
Grand Total 9804
Month Sales
April
Sales Conversion February
44.5% January 1E+05
33.8% March
30.2% May
49.5% Total Result 1E+05
37.9%
28.9%
88.9% April 1E+05
46.3% February 0
77.8% January 0
55.7% March 0
46.4% May 0
34.6%
24.5%
23.3%
89.3%
39.1%
18.9%
34.6%
70.7%
41.2%
67.0%
23.2%
39.5%
45.5%
15.6%
75.0%
20.0%
30.1%
57.6%
32.3%
77.0%
42.9%
100%