Cluster bar chart showing decline in market capitaliztion for Microsoft, Apple, Amzaon, Google and Facebook between Feb. 21, 2020 and Mar. 23, 2020.

Tech Giant Market Cap Decline

The five tech giants lost 24% of their market capitalization between February 21, 2020 and March 23, 2020, as shown in this cluster bar chart with bar comparison lines. Microsoft, Apple, Google and Facebook lost 24%, 28% 29% and 30%, respectively. Amazon fared best among the tech giants losing only 9% of its market cap. Among the tech giants, only Microsoft maintained its $1T+ valuation. Apple, Amazon and Google went from $1T+ to under $1T between the market high February 21 and its trough on March 23. Data came from Ycharts.

Tech Giants Market Cap Decline in a Cluster Bar Chart with Bar Comparison Lines

Cluster bar chart showing decline in market capitaliztion for Microsoft, Apple, Amzaon, Google and Facebook between Feb. 21, 2020 and Mar. 23, 2020.

How I Made this Cluster Bar Chart with Bar Comparison Lines

Here is the tech giants market cap data I used to create the cluster bar chart:

Cluster bar chart showing decline in market capitaliztion for Microsoft, Apple, Amzaon, Google and Facebook between Feb. 21, 2020 and Mar. 23, 2020.

Here's how I made the chart:

  • type the tech giants data from the ycharts website
  • press the switch bars and series button to treat rows as bars (e.g., company names) and columns as series (dates)
  • use formulas to compute the total decline and percentage decline and add them to the data sheet as shown
  • display rows 7 and 8 as data rows, noting that there is a blank space in cell A8
  • show legends at bottom of the chart
  • show values in the bars of the chart
  • add bar comparison lines within each cluster bar and show values and percentages in the bar comparison line labels
  • change the bar comparison line color and text color to red 
  • using right-click, select all bar comparison line labels, y axis label and segment label and use and in #,# number format of $B
  • in format axis task pane, show gridlines, hide y axis line and tick marks and x axis line and show number format on all y axis values
  • move labels for the data column items to form a single data column, set label colors to red and underline label header
  • change series colors
  • adjust internal chart margins and bar gaps

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more bar charts in our chart gallery. Here are some other charts that may be of interest: