| Smart Phone Brand | Jan 2018 | Feb 2018 | Mar 2018 | Apr 2018 | May 2018 | Jun 2018 | Jul 2018 | Aug 2018 | Sum of sales 2018 |
|---|---|---|---|---|---|---|---|---|---|
| Apple | 875 | 890 | 710 | 503 | 555 | 943 | 925 | 797 | 6198 |
| Samsung | 986 | 969 | 780 | 506 | 983 | 786 | 777 | 830 | 6617 |
| Huawei | 899 | 859 | 740 | 629 | 962 | 722 | 985 | 692 | 6488 |
| Sony | 706 | 730 | 790 | 599 | 796 | 680 | 699 | 977 | 5977 |
| LG | 733 | 952 | 724 | 654 | 514 | 984 | 991 | 842 | 6394 |
| HTC | 750 | 940 | 586 | 674 | 988 | 871 | 515 | 679 | 6003 |
| 861 | 555 | 622 | 883 | 627 | 734 | 939 | 519 | 5740 | |
| Xiaomi | 680 | 668 | 967 | 648 | 611 | 905 | 883 | 714 | 6076 |
| Asus | 799 | 827 | 560 | 898 | 573 | 598 | 514 | 853 | 5622 |
Instructions
Build a column chart and a stacked bar chart:
Change the type of the chart to "Column" (you can leave or remove the "3D" checkbox).
- Set the values in Values column: "Apr 2018", "May 2018", "Jun 2018".
- Set the Height of the chart 400 and the Width 600.
- Change the type of the chart to the Stacked column.
- Change the type of the chart to the Stacked bar.
- Select custom colors of bars by clicking the settings button
and "Select colors". Click the settings button
and "Save changes".
90 %
Training table
Smartphone Sales 2018