73 Free Designer Quality Excel Chart / Graph Templates
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / m
2. Stacked Charts / Graphs (22 templates, scroll down for more) 1 Grey-scale
Sample Chart $1,750
Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750
$275
$500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$200
$170 $250
$300
$350
2005
2006
2007
Products Excel
Power Point
Word
Outlook
2 Orange Parade
Sample Chart $175
2003
$100
$200
2004
Years2005
$125
$250
$-
$350
$250 $400
$200
$350
2007
$275
$170
$300
2006
$300
$350 $450
$275 $250
$325 $525
$500
$750
$375 $1,000
$1,250
$1,500
Sales in $ Mn Excel
Power Point
Word
Outlook
3 Blue Lagoon
Sample Chart $1,750
Sales in $ Mn
$1,500 $375
$1,250 $1,000 $750 $500 $250 $-
$325
$350
$525
$250
$275
$400
$350
$300 $100 $175
$125 $200
2003
2004
$450 $200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
$275
Word
Outlook
$1,750
Sales in $ Mn
$375
$1,250 $1,000
$325
$350
$750
$275
$500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
4 Red Red Roses
Sample Chart $175
2003
$100
$200
2004
Years2005
$300
$125
$250
$350
$170
$300
2006
$250 $400
$200
$350
2007
$275
$-
$350 $450
$275
$250
$325 $525
$500
$750
$375 $1,000
$1,250
$1,500
$1,750
Sales in $ Mn Excel
Power Point
Word
Outlook
5 Green Meadows
Sample Chart $1,750
Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750
$275
$500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
6 Another Blue
Sample Chart $175
2003
$100
$200
2004
Years2005
$125
$250
$-
$250
$250 $400
$200
$350
2007
$275
$350
$170
$300
2006
$300
$350 $450
$275 $500
$325 $525
$750
$375 $1,000
$1,250
Sales in $ Mn Excel
Power Point
Word
Outlook
$1,500
$1,750
$200
2004
Years2005
$125
$250
$350
$170
$300
2006
$400
$200
$350
2007
$250
$-
$350 $450
$325
$275
$250
$525
$500
$375
$750
$1,000
$1,250
$1,500
$1,750
Sales in $ Mn Excel
Power Point
Word
Outlook
7 Pattern Mania - Grey
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750 $500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
8 Pattern Mania - Blue
Sample Chart $175
2003
$100
$200
2004
Years2005
$300
$125
$250
$350 $170
$300
2006
$-
$250 $400
$200
$350
2007
$275
$350 $450
$325
$275 $250
$525
$500
$750
$375 $1,000
$1,250
$1,500
Sales in $ Mn Excel
Power Point
Word
Outlook
9 Pattern Mania - Green - 1
Sample Chart $175
2003
$100
$200
2004
Years2005
$125
$250
$-
$350
$250 $400
$200
$350
2007
$275
$170
$300
2006
$300
$350 $450
$275 $250
$500
$325 $525
$750
$375 $1,000
$1,250
Sales in $ Mn Excel
Power Point
Word
Outlook
$1,500
$1,750
$175
2003
$100
$200
2004
Years2005
$125
$250
$350
$-
$250 $400
$200
$350
2007
$275
$170
$300
2006
$300
$350 $450
$275 $250
$325 $525
$500
$750
$375 $1,000
$1,250
$1,500
Sales in $ Mn Excel
Power Point
Word
Outlook
10 Pattern Mania - Green - 2
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000 $750 $500 $250 $-
$325
$350
$525
$250
$275
$400
$350
$300 $100 $175
$125 $200
2003
2004
$450 $200
$170
$275
$250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
11 Pattern Mania - Yellow - 2
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000 $750 $500 $250 $-
$325
$350
$525
$250
$275
$400
$350
$300 $100 $175
$125 $200
2003
2004
$450 $200
$170
$275
$250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
12 Pattern Mania - Orange - 2
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000 $750 $500 $250 $-
$325
$350
$525
$250
$275
$400
$350
$300 $100 $175
$125 $200
2003
2004
$450 $200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
$275
Word
Outlook
$1,750
Sales in $ Mn
$1,250 $1,000
$325
$350
$750 $500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
13 Very very light - 1
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750 $500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
14 Dark Lord - 1
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750
$275
$500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
15 Dark Lord - 2
Sample Chart 20 03 20 04 20 Years 05 20 06 20 07
$175
$100
$200
$125
$250
$275 $350
$170
$300
$250
$250 $400
$200
$350
$-
$300
$350 $450
$275
$500
$325 $525
$750
$375
$1,000
Sales in $ Mn Excel
Power Point
Word
Outlook
$1,250
$1,500
$1,750
20 04 20 Years 05 20 06 20 07
$200
$125
$250
$350 $170
$300
$400
$200
$350
$-
$250 $350 $450
$325
$275
$250
$525
$500
$750
$375
$1,000
$1,250
$1,500
$1,750
Sales in $ Mn Excel
Power Point
Word
Outlook
16 Dark Lord - 3
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000
$325
$350
$750 $500
$100 $175
$125 $200
2003
2004
$-
$450
$400
$350
$300
$250
$525
$250
$275
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
17 Dark Lord - 4
Sample Chart 20 03 20 04 20 Years 05 20 06 20 07
$175
$100
$200
$125
$250
$275 $350
$250
$170
$300
$400
$200
$350
$-
$300
$350 $450
$275
$250
$325 $525
$500
$750
$375
$1,000
$1,250
$1,500
Sales in $ Mn Excel
Power Point
Word
Outlook
18 Wheat Field
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000 $750 $500 $250 $-
$325
$350
$525
$250
$275
$400
$350
$300 $100 $175
$125 $200
2003
2004
$450 $200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
$275
Word
Outlook
$1,750
Sales in $
$1,000
$350
$750
$275
$500
$-
$100 $175
$125 $200
2003
2004
$450
$400
$350
$300
$250
$525
$250
$275
$200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
Word
Outlook
19 Rainbow - 1
Sample Chart 2 003 2 004 2 Years 005 2 006 2 007
$175
$100
$200
$300
$125
$250
$275 $350
$170
$300
$250 $400
$200
$350
$-
$350 $450
$325
$275
$250
$525
$500
$750
$375
$1,000
$1,250
$1,500
$1,750
$1,500
$1,750
$1,500
$1,750
Sales in $ Mn Excel
Power Point
Word
Outlook
20 Rainbow - 2
Sample Chart 2 003 2 004 2 Years 005 2 006 2 007
$175
$100
$200
$300
$125
$250
$275 $350
$170
$300
$250 $400
$200
$350
$-
$350 $450
$325
$275
$250
$525
$500
$750
$375
$1,000
$1,250
Sales in $ Mn Excel
Power Point
Word
Outlook
21 Outline - 1
Sample Chart 2 003 2 004 2 Years 005 2 006 2 007
$175 $200
$250
$350 $450
$200
$350
$250 $400
$170
$300
$275
$350
$125
$250
$-
$300
$100
$525
$275
$500
$325
$750
$375
$1,000
Sales in $ Mn Excel
Power Point
Word
Outlook
$1,250
2 Years 005 2 006 2 007
$250 $300
$250
$350 $450
$200
$350
$-
$400
$170
$325 $525
$275
$500
$750
$375
$1,000
$1,250
$1,500
Sales in $ Mn Excel
Power Point
Word
Outlook
22 Outline - 2
Sample Chart Sales in $ Mn
$1,500 $375
$1,250 $1,000
$350
$750
$275
$500
$300
$250 $-
$325 $525
$250 $400
$350
$100 $175
$125 $200
2003
2004
$450 $200
$170 $250
$300
$350
2005
2006
2007
Years Excel
Power Point
$275
Word
Outlook
$1,750
[This is book 2 - see book 1 and 3 as well]
xtend / mail / save / modify as you like
Data used: Product Code Excel Power Point Word Outlook
2003 $175 $100 $300 $275
2004 $200 $125 $350 $250
2005 $250 $170 $400 $350
Sales (in 2006 $300 $200 $450 $325
mn $) 2007 $350 $275 $525 $375
How to use these templates? Method 1 : Simple and fast 1 Copy the chart you wanted and the data used portion above 2 Paste in your workbook 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"
2 In the dailog, go to "custom types" tab and select "User-defined" radio button (towards bott
3 Click on "Add…" button, and give your chart-template a name that you can remember
4 When you are done, click ok, and the chart is now added to your user-defined-charts library 5 In future, when you want to use the chart, simply click on charts icon on tool bar, and select 6 Now, watch out as your charts start stealing all eyes in boardroom
dio button (towards bottom left)
ou can remember
er-defined-charts library n on tool bar, and select the chart type as custom -> user defined ->your chart name