Daily Sales Dashboard in Excel

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Daily Sales

Month Dashboard July 2023

Daily Sales and Sales Conversion


12000

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

Sales Sales Conversion


ion

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%

You might also like