0% found this document useful (0 votes)
20 views18 pages

Chart & Graph

Uploaded by

esteem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
20 views18 pages

Chart & Graph

Uploaded by

esteem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

73 Free Designer Quality Excel Chart / Graph Templates

Created by [Link] - Point Haired Dilbert - Feel free to share / extend / mail / save / modi

2. Stacked Charts / Graphs (22 templates, scroll down for more)


1 Grey-scale

Sample Chart
$1,800
$1,600
$1,400
$375
$1,200
$325
Sales in $ Mn

$1,000 $350
$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007

Products Excel Power Point Word Outlook

2 Orange Parade

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275


Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook

3 Blue Lagoon

Sample Chart
$1,800
$1,600
$1,400
$375
$1,200
$325
Sales in $ Mn

$1,000 $350
$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook


Sample Chart
$1,800
$1,600
$1,400
$375
$1,200
$325

Sales in $ Mn
$1,000 $350
$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

4 Red Red Roses

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275


Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook

5 Green Meadows

Sample Chart
$1,800
$1,600
$1,400
$375
$1,200
$325
Sales in $ Mn

$1,000 $350
$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

6 Another Blue

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275


Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275


Years

$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800


Sales in $ Mn Excel Power Point Word Outlook

7 Pattern Mania - Grey

Sample Chart
$1,600

$1,400 $375

$1,200 $325
$350 $525
$1,000
Sales in $ Mn

$250 $450
$800 $275 $400
$600 $350
$275
$300
$400 $200
$170
$125 $350
$200 $100 $300
$250
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

8 Pattern Mania - Blue

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600
Sales in $ Mn Excel Power Point Word Outlook

9 Pattern Mania - Green - 1

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350


Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook

10 Pattern Mania - Green - 2

Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $350
$250 $300
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

11 Pattern Mania - Yellow - 2

Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $350
$250 $300
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

12 Pattern Mania - Orange - 2

Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Mn

$525
$800 $250
Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $350
$250 $300
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

13 Very very light - 1

Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $350
$250 $300
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

14 Dark Lord - 1

Sample Chart
$1,600

$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $350
$250 $300
$175 $200
$-
2003 2004 2005 2006 2007

Years Excel Power Point Word Outlook

15 Dark Lord - 2

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325


Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook

16 Dark Lord - 3

Sample Chart
$1,600
$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007
Years Excel Power Point Word Outlook

17 Dark Lord - 4

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook
18 Wheat Field

Sample Chart
$1,600
$1,400
$375
$1,200
$325
$1,000 $350
Sales in $ Mn

$525
$800 $250
$275 $450
$600 $400
$350 $275
$400 $300 $200
$170
$100 $125
$200 $300 $350
$175 $200 $250
$-
2003 2004 2005 2006 2007
Years Excel Power Point Word Outlook

19 Rainbow - 1

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Excel Power Point Word Outlook
Sales in $ Mn

20 Rainbow - 2

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275

Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook
21 Outline - 1

Sample Chart
2007 $350 $275 $525 $375

2006 $300 $200 $450 $325

2005 $250 $170 $400 $350

2004 $200 $125 $350 $250

2003 $175 $100 $300 $275


Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Excel Power Point Word Outlook
Sales in $ Mn

22 Outline - 2

Sample Chart
$1,600
$1,400 $375

$1,200 $325
$350 $525
$1,000
Sales in $ Mn

$250 $450
$800 $275 $400
$600 $350
$275
$300
$400 $200
$170
$125 $350
$200 $100 $250
$300
$175 $200
$-
2003 2004 2005 2006 2007
Years Excel Power Point Word Outlook
[This is book 2 - see book 1 and 3 as well]

extend / mail / save / modify as you like

Data used:

Sales (in mn $)
Product Code 2003 2004 2005 2006 2007
Excel $ 175 $ 200 $ 250 $ 300 $ 350
Power Point $ 100 $ 125 $ 170 $ 200 $ 275
Word $ 300 $ 350 $ 400 $ 450 $ 525
375 Outlook $ 275 $ 250 $ 350 $ 325 $ 375

525
How to use these templates?
275
Method 1 : Simple and fast
350

1 Copy the chart you wanted and the data used portion above
007
2 Paste in your workbook
Outlook
3 Change the values, remove columns (or add them if you wish)
4 Modify formatting if needed
5 Be careful now, as your boss may feel zealous for your charting skills

Method 2: Slightly geeky, but works like a charm

1 Select the chart you want, right click and select "Chart type"

$1,800
utlook

2 In the dailog, go to "custom types" tab and select "User-defined" radio button (towards b

375

525

275

350

2007
Outlook
375

525

275

350

2007
Outlook

3 Click on "Add…" button, and give your chart-template a name that you can remember

$1,800
utlook

4 When you are done, click ok, and the chart is now added to your user-defined-charts libr
$375 5 In future, when you want to use the chart, simply click on charts icon on tool bar, and se
6 Now, watch out as your charts start stealing all eyes in boardroom
$525

$275

$350

2007
d Outlook
$1,800
Outlook

$375

$525

$275

$350

2007
rd Outlook

$1,600
Outlook
0 $1,800
Outlook

$375

$525

$275

$350

2007
rd Outlook

$375

$525

$275

$350

2007
ord Outlook

$375

$525
$375

$525

$275

$350

2007
d Outlook

$375

$525

$275

$350

2007
d Outlook

375

525

275

350

2007
d Outlook
$1,800
ook

$375

525

275

350

007
ord Outlook

$1,800
ook
$375

$525

$275

$350

2007
ord Outlook

$1,800
ook

$1,800
ook
$1,800
utlook

$375

$525

$275

$350

2007
rd Outlook
fined" radio button (towards bottom left)
me that you can remember

your user-defined-charts library


harts icon on tool bar, and select the chart type as custom -> user defined ->your chart name

You might also like