#4682B4#FFFFFF2#4682B4Instructions

Build a column chart and a stacked bar chart:

  1. Change the type of the chart to Column (you can leave or remove the 3D checkbox).

  2. Set the values in Values column: Apr 2020, May 2020, Jun 2020.
  3. Set the Height of the chart 400 and the Width 600.
  4. Change the type of the chart to the Stacked column.
  5. Change the type of the chart to the Stacked bar.
  6. Select custom colors of bars by clicking the  icon and Select colors.

  7. Click the  icon and Save changes.

60

#4682B4#FFFFFF2#4682B4Training table

Smartphone Sales 2020

falseSmart Phone BrandApple‚Samsung‚Huawei‚Sony‚LG‚HTC‚Google‚Xiaomi‚AsusSum of sales 2018true1537266967942_-1067784077Donut2#8eb021,#d04437,#3572b0,#f6c342,#654982,#f691b2,#2484c1,#65a620,#7b6888
Smart Phone Brand Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sum of sales 2020
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
Google 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