excel charts
TRANSCRIPT
Pie chart1 GDP Share (%)
Agriculture 15
Industry 27
Service 58
GDP Components showing their share percentages out of total.
Pie chart in two plotCement Industry 20082 Name of the companies Market share(%)
Grasim Industries Ltd. 34.66ACC 18.03Ambuja Cement 11.88Ultratech Cements 11.44India Cement Ltd. 7.23Shree Cements 4.2Madras Cements 4.09Birla Corporation Ltd. 3.51JK Cement 2.97Binani Cement 1.99
In Indian cement industry, these are the market players and some of the companies are having very less %. Therefore, Prepare Pie chart in Two Plots
Top Ten Brands and their Comparison In US$mn3 Brands Brand Value 20Brand Value 2011
Google 36191 44294Microsoft 33604 42805Wal Mart 41365 36220
Agriculture15%
Industry27%
Service58%
Service dominates the GDP
IBM 33706 36157Vodafone 28995 30674Bank Of America 26047 30619General Electric 31909 30504Apple 19829 29543Wells Fargo 21916 28944AT&T 26585 28884
4 Tax collection by GovernmentRs in croreApr - Oct 2006 Apr - Oct 2007
Corporate Advance Tax 39139 50697Corporate Self assesmen3300 7253Personal Advance Tax 8000 10019Personal Self assesment3900 6161
Data shows Tax collection over a period of time. There are few points, show Comparision by selecting Column Chart.
Stacked column chart5 TCS
2009 2010
US 2098 2100UK 879 986EUROPE 675 776
AUS 578 588
Infosys Technology Revenue from different Geographies and Growth rate.6 Region 2009 2010
North America 8572.36 9873Europe 3393 4207India 214 219Rest of the world 1147 1349
Each region has different growth rate. Prepare column chart showing growth rate saperetely.
Line and column on two axis7 Period OPM %
JAS09 899.03 5.32
OND09 807.63 7.23
JFM10 926.07 9.5
AMJ10 1223 12.58
JAS10 1441.82 15.2
Correlation chart8 Discount(%) sales(in m)
4 2026 2448 2789 289
7 266
Net Sales(Rs Mn)
3 4 5 6 7 8 9 10150
170
190
210
230
250
270
290
310 Effect of Discount on Sales
Discount (%)
Sale
s (
in M
)
Relative performance9 Month Sensex Satyam
June 13560 65
July 14350 43
Aug 12900 33
Sep 11037 32
Oct 10689 24
Nov 9858 12
10 Inter-Firm Comparison:Rs mTCS INFY2009 2010 2009
SALES 14939.97 18533.72 13149% 33 24.05 45.65Data showing Revenue and growth of different companies. Prepare Column chart growth rate of each companies.
11 Sales Rs CroreFY2009 FY2010
PEPSI 1600 1900
3 4 5 6 7 8 9 10150
170
190
210
230
250
270
290
310 Effect of Discount on Sales
Discount (%)
Sale
s (
in M
)
COKE 1700 18007 UP 1800 2200
SPRITE 1900 2100
Q1 performance of 118 early birds
12 % growth rate for quarter endedJun-08 Jun-09
Net sales 29.04 7.83Total expenses 29.87 4.91Raw material 26.43 -5.24interest 59.95 28.23Net profit 16.6 17.24OPM 15.91 17.91Toatal cost as % of sales81.92 79.71RM/sales % 29.81 26.2
13 Gamble in MonsoonMonsoon rainfall and food grain production
Rainfall (% of Normal) Production (million tonnes)2000 92 196.82001 92 212.92002 81 174.82003 102 213.12004 87 198.4
2005 99 208.62006 100 217.32007 106 230.82008 98 233.9source- rainfall from IMD and Producton ministry of agriculture
14% Growth in NET PROFIT of three banks(2009)
HDFC BANK AXIS BANK YES BANKJune_ 0 46.6 88.7 50.9Sept_0843.3 76.9 40.5Dec_08 44.8 63.2 95Mar_09 33.9 60.9 24.2
P/E of key emerging countries15 Dec-07 Oct-08
Maxico Bosla 15.5 8.89Stock Exchange of Thai 44.28 5.28Jakarta composite Indon20.12 6.92Taiwan 18.97 7.37Hang seng(HIC) 20.6 7.75Kospi 18.09 8.05Karachi 100 16.09 8.99Sensex 15.2 9.18
Maxic
o B
osl
a
Sto
ck E
xch
an
ge o
f Th
aila
nd
Jakart
a c
om
posi
te I
nd
on
esi
a
Taiw
an
Han
g s
en
g(H
IC)
Kosp
i
Kara
ch
i 1
00
Sen
sex
01020304050
P/E of Emerging Countries
Dec-07
Oct-08
Countries
%
Maxic
o B
osl
a
Sto
ck E
xch
an
ge o
f Th
aila
nd
Jakart
a c
om
posi
te I
nd
on
esi
a
Taiw
an
Han
g s
en
g(H
IC)
Kosp
i
Kara
ch
i 1
00
Sen
sex
01020304050
P/E of Emerging Countries
Dec-07
Oct-08
Countries
%
GDP Components showing their share percentages out of total.
In Indian cement industry, these are the market players and some of the companies are having very less %.
Brand Value 2011
Agriculture15%
Industry27%
Service58%
Service dominates the GDP
35%
18%12%
11%
7%
4%
4%4% 3%2%
Grasim leads the MarketGrasim Industries Ltd.
ACC
Ambuja Cement
Ultratech Cements
India Cement Ltd.
Shree Cements
Madras Cements
Birla Corporation Ltd.
JK Cement
Binani Cement
Microsoft
Wal Mart
IBM
Vodafone
Bank Of America
General Electric
Apple
Wells Fargo
AT&T
0 10000 20000 30000 40000 50000
Google is leading Brand
Brand Value 2011
Brand Value 2010
Rupees
Bra
nd
s
Apr - Oct 2007
Data shows Tax collection over a period of time. There are few points, show Comparision by selecting Column Chart.
INFY2010 2009 2010
1765 2208 2298755 886 854665 754 778398 654 758
Microsoft
Wal Mart
IBM
Vodafone
Bank Of America
General Electric
Apple
Wells Fargo
AT&T
0 10000 20000 30000 40000 50000
Google is leading Brand
Brand Value 2011
Brand Value 2010
Rupees
Bra
nd
s
Corporate Advance Tax
Corporate Self assesment Tax
Personal Advance
Tax
Personal Self assesment Tax
0
10000
20000
30000
40000
50000
60000
Tax collection
Tax
Rs (Crores)
2009
2010
2010
2009
2010
TC
SIN
FY
0 500 1000 1500 2000 2500
AUS
EUROPE
UK
US
Com
pan
ies in
diff
years
North Amer-ica
Europe India Rest of the world
0
2000
4000
6000
8000
10000
12000
0
2
4
6
8
10
12
Growth n Revenue of Infosys
2009 2010
Countries
Revenue in R
s
Gro
wth
(%
)
Infosys Technology Revenue from different Geographies and Growth rate.
Each region has different growth rate. Prepare column chart showing growth rate saperetely.
North Amer-ica
Europe India Rest of the world
0
2000
4000
6000
8000
10000
12000
0
2
4
6
8
10
12
Growth n Revenue of Infosys
2009 2010
Countries
Revenue in R
s
Gro
wth
(%
)JAS09 OND09 JFM10 AMJ10 JAS10
0
200
400
600
800
1000
1200
1400
1600
0
2
4
6
8
10
12
14
16
Net Sales, OPM, Growth
Net Sales(Rs Mn) OPM % Time period
Net
Sale
s (
Cro
res)
Gro
wth
& O
PM
(%
)
3 4 5 6 7 8 9 10150
170
190
210
230
250
270
290
310 Effect of Discount on Sales
Discount (%)
Sale
s (
in M
)
Sensex Satyam100 100
105.8259587021 66.1538
95.13274336283 50.7692
81.39380530973 49.2308
78.82743362832 36.9231
72.69911504425 18.4615
SATYAM2010 2009 201015648.72 6228 813719.01 34.40 30.65
Data showing Revenue and growth of different companies. Prepare Column chart growth rate of each companies.
Growth (% CPLY)
18.8
3 4 5 6 7 8 9 10150
170
190
210
230
250
270
290
310 Effect of Discount on Sales
Discount (%)
Sale
s (
in M
)
June July Aug Sep Oct Nov0
20
40
60
80
100
120
Relative Performance of Satyam
Sensex SatyamMonths
%
2009 2010 2009 2010 2009 2010TCS INFY SATYAM
02000400060008000
100001200014000160001800020000
05101520253035404550
Inter Firm Comparison
SALES
%
Sale
s
PEPSI COKE 7 UP SPRITE0
500
1000
1500
2000
2500
0.0
5.0
10.0
15.0
20.0
25.0
Sales & Growth of Companies
Sales Rs Crore FY2009 FY2010Growth (% CPLY)
Companies
Sale
s (
Rs C
rore
)
Gro
wth
(%
)
5.922.2
10.5
PEPSI COKE 7 UP SPRITE0
500
1000
1500
2000
2500
0.0
5.0
10.0
15.0
20.0
25.0
Sales & Growth of Companies
Sales Rs Crore FY2009 FY2010Growth (% CPLY)
Companies
Sale
s (
Rs C
rore
)
Gro
wth
(%
)
Net
sale
s
Tota
l expense
s
Raw
mate
rial
inte
rest
Net
pro
fit
OPM
Toata
l co
st a
s %
of
sale
s
RM
/sale
s %-50
0
50
100
% Growth Rate
Jun-08 Jun-09
2000 2001 2002 2003 2004 2005 2006 2007 20080
50
100
150
200
250
Rainfall (% of Normal) Production (million tonnes)
source- rainfall from IMD and Producton ministry of agriculture2000 2001 2002 2003 2004 2005 2006 2007 2008
0
50
100
150
200
250
Rainfall (% of Normal) Production (million tonnes)
June_ 08 Sept_08 Dec_08 Mar_09
0
10
20
30
40
50
60
70
80
90
100
% Growth in Net Profit of Banks
HDFC BANK AXIS BANK YES BANK
Time Period
Gro
wth
(%)
Maxic
o B
osl
a
Sto
ck E
xch
an
ge o
f Th
aila
nd
Jakart
a c
om
posi
te I
nd
on
esi
a
Taiw
an
Han
g s
en
g(H
IC)
Kosp
i
Kara
ch
i 1
00
Sen
sex
01020304050
P/E of Emerging Countries
Dec-07
Oct-08
Countries
%
Maxic
o B
osl
a
Sto
ck E
xch
an
ge o
f Th
aila
nd
Jakart
a c
om
posi
te I
nd
on
esi
a
Taiw
an
Han
g s
en
g(H
IC)
Kosp
i
Kara
ch
i 1
00
Sen
sex
01020304050
P/E of Emerging Countries
Dec-07
Oct-08
Countries
%
Corporate Advance Tax
Corporate Self assesment Tax
Personal Advance
Tax
Personal Self assesment Tax
0
10000
20000
30000
40000
50000
60000
Tax collection
Tax
Rs (Crores)
2009
2010
2010
2009
2010
TC
SIN
FY
0 500 1000 1500 2000 2500
AUS
EUROPE
UK
US
Com
pan
ies in
diff
years
North Amer-ica
Europe India Rest of the world
0
2000
4000
6000
8000
10000
12000
0
2
4
6
8
10
12
Growth n Revenue of Infosys
2009 2010
Countries
Revenue in R
s
Gro
wth
(%
)
North Amer-ica
Europe India Rest of the world
0
2000
4000
6000
8000
10000
12000
0
2
4
6
8
10
12
Growth n Revenue of Infosys
2009 2010
Countries
Revenue in R
s
Gro
wth
(%
)
June July Aug Sep Oct Nov0
20
40
60
80
100
120
Relative Performance of Satyam
Sensex SatyamMonths
%
2009 2010 2009 2010 2009 2010TCS INFY SATYAM
02000400060008000
100001200014000160001800020000
05101520253035404550
Inter Firm Comparison
SALES
%
Sale
s
PEPSI COKE 7 UP SPRITE0
500
1000
1500
2000
2500
0.0
5.0
10.0
15.0
20.0
25.0
Sales & Growth of Companies
Sales Rs Crore FY2009 FY2010Growth (% CPLY)
Companies
Sale
s (
Rs C
rore
)
Gro
wth
(%
)
PEPSI COKE 7 UP SPRITE0
500
1000
1500
2000
2500
0.0
5.0
10.0
15.0
20.0
25.0
Sales & Growth of Companies
Sales Rs Crore FY2009 FY2010Growth (% CPLY)
Companies
Sale
s (
Rs C
rore
)
Gro
wth
(%
)
June_ 08 Sept_08 Dec_08 Mar_09
0
10
20
30
40
50
60
70
80
90
100
% Growth in Net Profit of Banks
HDFC BANK AXIS BANK YES BANK
Time Period
Gro
wth
(%)
Pie chart1 GDP Share (%)
Agriculture 18
Industry 27
Service 55
GDP Components showing their share percentages out of total.
Pie chart in two plotCement Industry 20082 Name of the companies Market share(%)
Grasim Industries Ltd. 34.66ACC 18.03Ambuja Cement 11.88Ultratech Cements 11.44India Cement Ltd. 7.23Shree Cements 4.2Madras Cements 4.09Birla Corporation Ltd. 3.51JK Cement 2.97Binani Cement 1.99
In Indian cement industry, these are the market players and some of the companies are having very less %. Therefore, Prepare Pie chart in Two Plots
Sensex slips 55% but Indian stock still expensive3 P/E of key emerging countrDec-07
Maxico Bosla 15.5Stock Exchange of Thailan 44.28Jakarta composite Indones20.12Taiwan 18.97Hang seng(HIC) 20.6Kospi 18.09Karachi 100 16.09Sensex 15.2
Data shows comparison between different stock exchanges. Prepare bar chart.
4 Tax collection by GovernmentRs in croreApr - Oct 2006
Corporate Advance Tax 39139Corporate Self assesment 3300Personal Advance Tax 8000
Personal Self assesment Ta3900Data shows Tax collection over a period of time. There are few points, show Comparision by selecting Column Chart.
Stacked column chart5 TCS
2007US 2098UK 879EUROPE 675AUS 578
Infosys Technology Revenue from different Geographies and Growth rate.6 Region 2006-07
North America 8572.36Europe 3393India 214Rest of the world 1147
Each region has different growth rate. Prepare column chart showing growth rate saperetely.
Line and column on two axis7 Period Net Sales(Rs Mn)
JAS06 899.03
OND06 807.63
JFM07 926.07
AMJ07 1223
JAS07 1441.82
Correlation chart8 Discount(%) sales(in m)
4 2026 2448 2789 2897 266
Relative performance9 Month Sensex
June 13560
July 14350
Aug 12900
Sep 11037
Oct 10689
Nov 9858
10 Inter-Firm Comparison: Rs mTCS2007 2008
SALES 14939.97 18533.72% 33 24.05Data showing Revenue and growth of different companies. Prepare Column chart growth rate of each companies.
11 Sales Rs Crore2007
PEPSI 1600COKE 17007 UP 1800SPRITE 1900
Q1 performance of 118 early birds
12 % growth rate for quarter endedJun-08
Net sales 29.04Total expenses 29.87Raw material 26.43interest 59.95Net profit 16.6OPM 15.91Toatal cost as % of sales 81.92RM/sales % 29.81
13 Gamble in MonsoonMonsoon rainfall and food grain production
Rainfall (% of Normal) Production (million tonnes)2000 92 196.82001 92 212.92002 81 174.82003 102 213.12004 87 198.42005 99 208.62006 100 217.32007 106 230.8
2008 98 233.9source- rainfall from IMD and Producton ministry of agriculture
14% Growth in NET PROFIT of three banks
HDFC BANK AXIS BANKJune_ 08 46.6 88.7Sept_08 43.3 76.9Dec_08 44.8 63.2Mar_09 33.9 60.9
GDP Components showing their share percentages out of total.
Market share(%)
In Indian cement industry, these are the market players and some of the companies are having very less %.
Oct-088.895.286.927.377.758.058.999.18
Data shows comparison between different stock exchanges. Prepare bar chart.
Apr - Oct 2007 Apr - Oct 200850697 610177253 1352710019 7424
6161 8947Data shows Tax collection over a period of time. There are few points, show Comparision by selecting Column Chart.
RS m
WIPRO INFY2008 2007 2008 2007 2008
2100 1675 1765 2208 2298986 765 755 886 854776 543 665 754 778588 378 398 654 758
Infosys Technology Revenue from different Geographies and Growth rate. Rs m2007-08 % Growth9873 15.24207 24.0219 2.31349 17.6
Each region has different growth rate. Prepare column chart showing growth rate saperetely.
OPM % NPM %
5.32 2.1
7.23 3.07
9.5 5.2
12.58 7.6
15.2 8.65
Satyam65
43
33
32
24
12
INFY SATYAM2007 2008 2007 200813149 15648.72 6228 813745.65 19.01 34.40 30.65
Data showing Revenue and growth of different companies. Prepare Column chart growth rate of each companies.
Growth (% CPLY)20081900 18.81800 5.92200 22.22100 10.5
Jun-097.834.91-5.2428.2317.2417.9179.7126.2
Production (million tonnes)
YES BANK50.940.5
9524.2
Line and column on two axis
13 % Change Net sales 33511 25.9
1849 3.8
6513 42.6
5846 18.9
Interest 7404 30.1
Net profit 5181 3.5
PBDIT 14847 15.8
Line chart14 Month WPI Inflation
4-Aug-07 4.4### 3.2### 8.3May 10,208.6May 24,208.2### 11.1### 11.65-Jul-08 11.919-Jul-08 11.9826-Jul-08 12.01### 12.44
Line and column on two axis
15
Year
Rs/$
1992-93 1544 31.2
1993-94 5445 31.4
1994-95 4777 31.5
1995-96 6721 34.4
1996-97 7386 35.9
1997-98 5908 39.5
1998-99 -729 42.4
1999-00 9765 43.6
2000-01 9683 46.6
2001-02 8273 48.8
2002-03 2669 47.5
2003-04 44000 43.4
2004-05 41416 43.8
2005-06 48650 44.6
2006-07 23754 43.6
2007-08 34720 39.9
Line chart
Company x
Rs in (Cr)
Other incomeRaw materialEmploy cost
Total FII Investments
16 Periods Mining ManufacElectricityJun-07Jul-07 -1.01 -0.26 2.13Aug-07 -0.64 2.31 1.71Sep-07 -1.28 0.64 -4.46Oct-07 10.13 -0.28 5.38Nov-07 2.71 -0.46 -4.74Dec-07 5.68 9.82 4.13Jan-08 1.41 -1.44 1.91Feb-08 -1.66 -1.69 -5.59Mar-08 12.09 10.48 7.48Apr-08 -16.96 -13.08 -3.92May-08 3.34 2.53 5.45Jun-08 -7.59 -0.82 -5.65
Column chart17 Rs in (Cr)
Period Fiscal DRevenue DeficitJFM07 77740 70675AMJ07 86461 69277JAS07 94854 66777OND07 1E+05 80221JFM08 1E+05 68646AMJ08 81200 61124JAS08 77578 39210OND08 1E+05 55535
Column /bar chart18 Rs in (Cr)
Periods Export IMPORTAMJ 06-07### ###JAS 06-07 ### ###OND 06-0 ### ###JFM 06-07### ###AMJ 07-08### ###JAS 07-08 ### ###OND 07-0 ### ###JFM 07-08### ###
Line chart19 Periods ReverseRepo RaCRR
01.01.07 6 7.25 5.531.12.07 6 7.5 5.517.02.07 6 7.5 5.7503.03.07 6 7.5 631.03.07 6 7.75 6
IIP Components % growth rate
14.04.07 6 7.75 6.2528.04.07 6 7.75 6.501.08.07 6 7.75 710.11.07 6 7.75 7.526.04.08 6 7.75 7.7510.05.08 6 7.75 824.05.08 6 7.75 8.2512.06.08 6 8 8.2525.06.08 6 8.5 8.2505.07.08 6 8.5 8.519.07.08 6 8.5 8.75
Line chart20 Periods CALL REPO CBLO
AMJ 06 6.1 5.97 5.88JAS 06 7.31 6.84 6.62OND 06 9.53 7.39 7.2JFM 07 5.79 4.51 4.13AMJ 08 4.24 3.81 3.59JAS 08 6.85 6.73 6.51OND 08 6.93 6.69 6.36JFM 08 6.83 6.64 6.19