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.


Smartphone Sales 2020

Smart Phone BrandJan 2020Feb 2020Mar 2020Apr 2020May 2020Jun 2020Jul 2020Aug 2020Sum of sales 2020
Apple8758907105035559439257976198
Samsung9869697805069837867778306617
Huawei8998597406299627229856926488
Sony7067307905997966806999775977
LG7339527246545149849918426394
HTC7509405866749888715156796003
Google8615556228836277349395195740
Xiaomi6806689676486119058837146076
Asus7998275608985735985148535622