Create your first interactive chart in ExcelMake Awesome Charts
Month Soap Handwash Shampoo Conditioner Shaving Cream
Mar-17 620 660 800 730 790
Apr-17 530 610 960 730 840
May-17 430 720 910 790 980
Jun-17 380 690 1110 690 970
Jul-17 560 840 1230 590 880
Aug-17 570 1030 1180 780 1070
Sep-17 590 1140 1280 900 1030
Oct-17 560 1200 1310 1060 1170
Nov-17 760 1220 1280 1120 1290
Dec-17 880 1170 1370 1050 1360
Jan-18 820 1250 1560 1240 1500
Feb-18 790 1300 1690 1290 1680
Mar-18 930 1240 1660 1320 1610
Step 5: Column chart from [picked product]
Picked Product
1400
1200
1000
800
600
400
200
0
1 2 3 4 5 6 7 8 9 10 11 12 13
After adding axis labels
Picked Product
1400
1200
1000
800
600
400
200
0
Mar-17 May-17 Jul -17 Sep-17 Nov-17 Jan-18 Ma r-18
After removing title and chart border
1400
1200
1000
800
600
400
1200
1000
800
600
400
200
0
Ma r-17 May-17 Jul -17 Sep-17 Nov-17 Ja n-18 Mar-18
Make Awesome Charts
4
Conditioner
Deodorant Picked Product Message
990 730 Quantity up by 81%
1120 730
1270 790 2000
Quantity over time - Mar 2017 to 201
1440 690
1510 590 1500
1570 780
1700 900
1000
1630 1060
1610 1120
1710 1050 500
1710 1240
1840 1290 0
Mar-17 May-17 Jul-17 Sep-17 Nov-17
1740 1320
Conditioner
Quantity up by 81%
Quantity over time - Mar 2017 to 2018
17 May-17 Jul-17 Sep-17 Nov-17 Jan-18 Mar-18
Create your first interactive chart in Excel
Month Product Quantity Month Sum - Quantity
Mar-17 Conditioner 730 Jan 8080
Mar-17 Deodorant 990 Feb 8590
Mar-17 Handwash 660 Mar 13090
Mar-17 Shampoo 800 Apr 4790
Mar-17 Shaving Cream 790 May 5100
Mar-17 Soap 620 Jun 5280
Apr-17 Conditioner 730 Jul 5610
Apr-17 Deodorant 1120 Aug 6200
Apr-17 Handwash 610 Sep 6640
Apr-17 Shampoo 960 Oct 6930
Apr-17 Shaving Cream 840 Nov 7280
Apr-17 Soap 530 Dec 7540
May-17 Conditioner 790 Total Result 85130
May-17 Deodorant 1270
May-17 Handwash 720
May-17 Shampoo 910
May-17 Shaving Cream 980
May-17 Soap 430
Jun-17 Conditioner 690
Jun-17 Deodorant 1440
Jun-17 Handwash 690
Jun-17 Shampoo 1110
Jun-17 Shaving Cream 970
Jun-17 Soap 380
Jul-17 Conditioner 590
Jul-17 Deodorant 1510
Jul-17 Handwash 840
Jul-17 Shampoo 1230
Jul-17 Shaving Cream 880
Jul-17 Soap 560
Aug-17 Conditioner 780
Aug-17 Deodorant 1570
Aug-17 Handwash 1030
Aug-17 Shampoo 1180
Aug-17 Shaving Cream 1070
Aug-17 Soap 570
Sep-17 Conditioner 900
Sep-17 Deodorant 1700
Sep-17 Handwash 1140
Sep-17 Shampoo 1280
Sep-17 Shaving Cream 1030
Sep-17 Soap 590
Oct-17 Conditioner 1060
Oct-17 Deodorant 1630
Oct-17 Handwash 1200
Oct-17 Shampoo 1310
Oct-17 Shaving Cream 1170
Oct-17 Soap 560
Nov-17 Conditioner 1120
Nov-17 Deodorant 1610
Nov-17 Handwash 1220
Nov-17 Shampoo 1280
Nov-17 Shaving Cream 1290
Nov-17 Soap 760
Dec-17 Conditioner 1050
Dec-17 Deodorant 1710
Dec-17 Handwash 1170
Dec-17 Shampoo 1370
Dec-17 Shaving Cream 1360
Dec-17 Soap 880
Jan-18 Conditioner 1240
Jan-18 Deodorant 1710
Jan-18 Handwash 1250
Jan-18 Shampoo 1560
Jan-18 Shaving Cream 1500
Jan-18 Soap 820
Feb-18 Conditioner 1290
Feb-18 Deodorant 1840
Feb-18 Handwash 1300
Feb-18 Shampoo 1690
Feb-18 Shaving Cream 1680
Feb-18 Soap 790
Mar-18 Conditioner 1320
Mar-18 Deodorant 1740
Mar-18 Handwash 1240
Mar-18 Shampoo 1660
Mar-18 Shaving Cream 1610
Mar-18 Soap 930
Make Awesome Charts
Total Quantity
90000
80000 This shape
represents a slicer.
70000
Slicers are
60000 supported in Excel
2010 or later.
50000
40000 If the shape was
modified in an
30000
earlier version of
20000 Excel, or if the
workbook was
10000
saved in Excel
0 2003 or earlier, the
n b ar Ap
r ay n Ju
l g p
Oc
t v c
No D e s u
lt slicer cannot be
Ja Fe M M Ju Au Se e
lR used.
ta
To
This shape
represents a slicer.
Slicers are
supported in Excel
2010 or later.
If the shape was
modified in an
earlier version of
Excel, or if the
workbook was
saved in Excel
2003 or earlier, the
slicer cannot be
used.
