Column Chart

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 14

ABC Company

Region Jan Feb Mar Apr May


US 20000 22000 19000 23000 24000
Europe 14500 14600 14500 14450 16000
Asia 26000 17000 18000 28000 30000
South America 5000 3000 3500 6000 2000

Column Charts

Clustered Column Stacked Column


35000 80000
30000 70000
25000 60000
50000
20000
40000
15000 30000
10000 20000
5000 10000
0 0
Jan Feb Mar Apr May Jan Feb Mar Apr M

US Europe Asia South America US Europe Asia South America

Bar Charts

Clustered Bar Stacked Bar


May May
Apr Apr
Mar Mar
Feb Feb
Jan Jan
0 5000 10000 15000 20000 25000 30000 35000 0 10000 20000 30000 40000 50000 60000 70000

South America Asia Europe US US Europe Asia South America


cked Column 100% Stacked Column
100%
80%
60%
40%
20%
0%
Mar Apr May Jan Feb Mar Apr May

ope Asia South America US Europe Asia South America

tacked Bar 100% Stacked Bar


May
Apr
Mar
Feb
Jan
00 40000 50000 60000 70000 80000 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

pe Asia South America US Europe Asia South America


Date AAPL MSFT
3/10 7.20% 6.84% 1) The Stacked Column Chart (More Data) has too many data points, an
3/11 -3.47% -4.53% 2) The Stacked Column Chart (Less Data) is an improvement, but still ha
3/12 -9.88% -9.48% 3) The Clustered Column Chart does a better job of displaying a compa
3/13 11.98% 14.22%
3/16 -12.86% -14.74%
3/17 4.40% 8.23%
Stacked Column Chart (More Data)
3/18 -2.45% -4.21%
3/19 -0.77% 1.65% 30.00%
3/20 -6.35% -3.76%
25.00%
3/23 -2.12% -1.00%
3/24 10.03% 9.09% 20.00%
3/25 -0.55% -0.96%
3/26 5.26% 6.26% 15.00%
3/27 -4.14% -4.11%
3/30 2.85% 7.03% 10.00%

3/31 -0.20% -1.57%


5.00%
4/1 -5.26% -3.55%
4/2 1.67% 2.07% 0.00%
4/3 -1.44% -0.92% 0 3 6 9 2 5 8 1 3 6 9 2 5 8 1 4 7
3/1 3/1 3/1 3/1 3/2 3/2 3/2 3/3 4/ 4/ 4/ 4/1 4/1 4/1 4/2 4/2 4/2 4/3
4/6 8.72% 7.44% -5.00%
4/7 -1.16% -1.08%
4/8 2.56% 1.00% -10.00%

4/9 0.72% 0.01%


-15.00%
4/13 1.96% 0.22%
4/14 5.05% 4.95% -20.00%
4/15 -0.91% -1.05%
4/16 0.79% 3.00% AAPL MSFT
4/17 -1.36% 0.88%
4/20 -2.08% -1.98%
4/21 -3.09% -4.14%
4/22 2.88% 3.40%
4/23 -0.39% -1.21%
4/24 2.89% 1.83%
4/27 0.07% -0.29%
4/28 -1.62% -2.44%
4/29 3.28% 4.49%
4/30 2.11% 1.00%
5/1 -1.61% -2.59%
5/4 1.41% 2.45%
5/5 1.50% 1.07%
5/6 1.03% 0.98%
5/7 1.03% 0.58%
Stacked Column Ch
30.00%

25.00%

20.00%

15.00%

10.00%

5.00%

0.00%
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 4/1 4/2 4/3 4/4 4/5 4/6 4/7
3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/
-5.00%

-10.00%

-15.00%

-20.00%

AAPL
has too many data points, and the returns for both stocks are added.
s an improvement, but still has the issue of adding the two stock returns.
tter job of displaying a comparison of the returns of two companies.

art (More Data) Stacked Column Chart (Less Data)


30.00%
25.00%
20.00%
15.00%
10.00%
5.00%
0.00%
-5.00% 3/10 3/11 3/12 3/13 3/14 3/15 3/16 3/17 3/18 3/19 3/20 3/21 3/22 3/23 3/24 3/25 3/26
-10.00%
-15.00%
-20.00%
9 2 5 8 1 4 7 0 3 6
4/ 4/1 4/1 4/1 4/2 4/2 4/2 4/3 5/ 5/ AAPL MSFT

Clus ter ed Colum n Char t


AAPL MSFT
20.00%

15.00%
MSFT
10.00%

5.00%

0.00%
3/10 3/11 3/12 3/13 3/14 3/15 3/16 3/17 3/18 3/19 3/20 3/21 3/22 3/23 3/24 3/25 3/26
-5.00%

-10.00%

-15.00%

-20.00%
Stacked Column Chart (More Data)

1 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5
4/ 4/ 4/ 4/ 4/ 4/ 4/ 4/ 4/ 4/1 4/1 4/1 4/1 4/1 4/1 4/1 4/1 4/1 4/1 4/2 4/2 4/2 4/2 4/2 4/2 4/2 4/2 4/2 4/2 4/3 5/ 5/ 5/ 5/ 5/

AAPL MSFT
/23 3/24 3/25 3/26

/23 3/24 3/25 3/26


28 /29 /30 5/1 5/2 5/3 5/4 5/5 5/6 5/7
4 4
Revenue Q1 Q2 Q3 Q4
East 1000.00 1200.00 1100.00 1250.00
South 800.00 900.00 1200.00 1800.00
North 600.00 2400.00 2300.00 200.00
West 500.00 500.00 500.00 500.00

Chart Title Cha


East South North West
East So

500 500
500

2300 500
2400 200 2400
500
500
600 1800
1200 600
900
800 900
800
1000 1200 1100 1250
1000 1200
Q1 Q2 Q3 Q4
Q1 Q2
Chart Title
East South North West

500 500

2300 500
2400 200
500
600 1800
900 1200
800

1000 1200 1100 1250

Q1 Q2 Q3 Q4
Market Share Google Bing & Yahoo Other
Oct-18 90.28% 6.58% 1.56%
Jan-19 89.95% 6.83% 1.55%
Apr-19 88.47% 7.94% 1.58%
Jul-19 88.61% 7.70% 1.56%
Oct-19 87.96% 7.99% 1.38%
Jan-20 87.35% 8.36% 1.46%
Source: https://www.statista.com/statistics/216573/worldwide-market-share-of-search-engines/

Market Share for Search Engines


100.00%

98.00% 1.56% 1.55% 1.58% 1.56% 1.38% 1.46%


96.00%

94.00% 6.58%
6.83%
7.94% 7.70%
92.00% 7.99% 8.36%
90.00%

88.00%

86.00%
90.28% 89.95%
84.00% 88.47% 88.61% 87.96% 87.35%
82.00%

80.00%
8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 0
t-1 ov-1 ec-1 an-1 eb-1 ar-1 pr-1 ay-1 un-1 ul-1 ug-1 ep-1 ct-1 ov-1 ec-1 an-2
Oc N D J F M A M J J A S O N D J

Google Bing & Yahoo Other


Quarter Google Bing & Yahoo Other
Oct-18 90.28% 6.58% 1.56%
Jan-19 89.95% 6.83% 1.55%
Apr-19 88.47% 7.94% 1.58%
Jul-19 88.61% 7.70% 1.56%
Oct-19 87.96% 7.99% 1.38%
Jan-20 87.35% 8.36% 1.46%
Source: https://www.statista.com/statistics/216573/worldwide-market-share-of-search-engines/
Market Share Google Bing & Yahoo Other
Oct-18 90.28% 6.58% 1.56%
Jan-19 89.95% 6.83% 1.55% Search Engine M
Apr-19 88.47% 7.94% 1.58% 1.56% 1.55% 1.58
Jul-19 88.61% 7.70% 1.56% 95.00%
6.58% 6.83% 7.94
Oct-19 87.96% 7.99% 1.38%
85.00%

75.00%

90.28% 89.95% 88.47


65.00%

55.00%

45.00%
Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-1

Google Bing & Yah


earch Engine Market Share
5% 1.58% 1.56% 1.38%
3% 7.94% 7.70% 7.99%

95% 88.47% 88.61% 87.96%

-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19

Google Bing & Yahoo Other

You might also like