73 Designed Quality Excel Chart Templates
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 73 Designed Quality Excel Chart Templates as PDF for free.
More details
- Words: 4,307
- Pages: 63
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
1. Column / Bar Charts (29 templates, scroll down to see more) 1 Grey-scale
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525
$450 $400 $350
$350
$300
$275
$250 $200 $175
$350 $325
$300
$375
2005
$200 $170
2006 2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
2 Orange Parade
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $275
$250 $200 $175
$375 $350 $325
$350
$300
$300
$275 $250
2004 2005 2006
$200 $170
2007
$125 $100
Excel
2003
Power Point
Word
Outlook
Products
3 Blue Lagoon
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2005
$200 $170
2006 2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
4 Red Red Roses
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2005 2006
$200 $170
2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
5 Green Meadows
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word
Outlook
Products
6 Another Blue
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2003 2004
$275 $250
2005 2006
$200 $170
2007
$125 $100
Excel
Power Point
Word
Outlook
Products
7 Pattern Mania - Grey
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$275
$250 $200 $175
$375 $350 $325
$350
$300
$300
$275 $250
2004 2005 2006
$200 $170 $125 $100
$100
2003
2007
$Excel
Power Point
Word
Outlook
Products
8 Pattern Mania - Blue
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
2004 2005 2006
$200 $170 $125 $100
$100
2003
2007
$Excel
Power Point
Word
Outlook
Products
9 Pattern Mania - Green - 1
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
$Excel
2004 2005 2006 2007
$125 $100
$100
2003
Power Point Products
Word
Outlook
$525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
2003 2004 2005 2006
$200 $170
2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
10 Pattern Mania - Green - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $175
$375 $350 $325
$350
$200
$300
2005 2006
$200 $170 $100
Excel
2003 2004
$275 $250
2007
$125
Power Point
Word
Outlook
Products
11 Pattern Mania - Yellow - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $175
$375 $350 $325
$350
$200
$300
2005 2006
$200 $170 $100
Excel
2003 2004
$275 $250
2007
$125
Power Point
Word
Outlook
Products
12 Pattern Mania - Yellow - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$300
$350
$375 $325
$275 $250
$200
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$350
$300
$375 $325
2003 2004
$275 $250
2005
$200
2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
13 Pattern Mania - Orange - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$350
$300
$375 $325
2003 2004
$275 $250
2005
$200
2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
14 Pattern Mania - Orange - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$350
$300
$275
$375 $325
$250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
15 On a pink day
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350 $300 $250 $200 $175
$100
$350 $275
$300
$375 $350 $325 $275 $250
$200 $170 $125 $100
2004 2005 2006 2007
$Excel
2003
Power Point Products
Word
Outlook
Sales in $ M
$400
$400
$350 $300
$300 $200
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170 $125 $100
$100
2003 2004 2005 2006 2007
$Excel
Power Point
Word
Outlook
Products
16 Very very light - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
17 On a rainy day
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
18 Dark Lord - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$275 $250
$200 $170 $100
Excel
$300
$375 $350 $325
2003 2004 2005 2006 2007
$125
Power Point Products
Word
Outlook
Sales in $
$350 $300 $250 $200 $150 $100 $50 $-
$350
$350
$300
$275
$250 $200 $175
$350 $325
$300
$275 $250
$200 $170 $100
Excel
2003 2004 2005 2006 2007
$125
Power Point
Word
Outlook
Products
19 Dark Lord - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2003
2006 2007
$125
Power Point
Word
Outlook
Products
20 Dark Lord - 3
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2003
2006 2007
$125
Power Point
Word
Outlook
Products
21 Dark Lord - 4
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$300
$275
$250
$200 $170 $100
Excel
$375 $350 $325
$350
2003 2004 2005 2006 2007
$125
Power Point Products
Word
Outlook
Sales in
$300 $250 $200 $150 $100 $50 $-
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2006 2007
$125
Power Point
Word
Outlook
Products
22 Wheat Field
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
2005
$200 $170 $100
Excel
2003 2004
$275 $250
2006 2007
$125
Power Point
Word
Outlook
Products
23 Rainbow - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
24 Rainbow - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales i
$250 $200 $150 $100 $50 $-
$250
$250
$200 $175
$200 $170
2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
25 Lavender Love
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
26 Outline - 1
Sample Chart $600
$525
Sales in $ Mn
$500
$450 $400
$400
$350 $300 $250
$300 $200
$200 $175
$275
$350 $300
$375 $350 $325 $275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
27 Outline - 2
Sample Chart $600
$525
Sales in $ Mn
$500 $400 $300 $200
$450 $400 $350 $300 $250 $200 $175
$275
$350 $300
$375 $350 $325 $275 $250
$200 $170
Power Point Products
2005 2007
$Excel
2004 2006
$125 $100
$100
2003
Word
Outlook
Sal
$200
$200 $170
$200 $175
2006 2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
28 Pseudo Incell
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350 $300
$300 $200
$350 $275
$250 $175
$200
$170 $100
$100
$350
$300
$275
$375 $325
2003 2004 2005
$250
2006
$200
2007
$125
$Excel
Power Point
Word
Outlook
Products
29 Trance - Equalizer
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$350
$300
$275
$250 $175
$200
$170 $100
$100
$300
$350 $275
$375 $325
$250
$200
2004 2005 2006 2007
$125
$Excel
2003
Power Point Products
Word
Outlook
[This is book 1 - see book 2 and 3 also]
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
Sales (in 2005 2006 $250 $300 $170 $200 $400 $450 $350 $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
73 Free Designer Quality Excel Chart / Graph Templates
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / mo
2. Stacked Charts / Graphs (22 templates, scroll down for more) 1 Grey-scale
Sample Chart 1750
Sales in $ Mn
1500 375
1250 1000
325
350
750
250
275
500 250 0
100 175
125
2003
2004
Power Point Excel
275
200
170
200
Word
450
400
350
300
Outlook
525
250
300
350
2005
2006
2007
Products
2 Orange Parade
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
1250
1500
1750
Sales in $ Mn
3 Blue Lagoon
Sample Chart 1750
Sales in $ Mn
1500 375
1250 1000 750 500 250 0
350 275 300
250 350
400 170
325
Outlook
525
200
Excel
275
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
Word Power Point
450
Sal
500 250 0
400
350
300
Excel
275
200
170
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
4 Red Red Roses
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
400
200
350
2007
0
450
Power Point Excel
325
275 250
Word
350
525
500
750
375 1000
1250
1500
1750
Sales in $ Mn
5 Green Meadows
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
200
2003
2004
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
250
300
350
2005
2006
2007
Years
6 Another Blue
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
Sales in $ Mn
1250
1500
1750
7 Pattern Mania - Grey
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
2003
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
200
250
300
350
2004
2005
2006
2007
Years
8 Pattern Mania - Blue
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
400 200
350
2007
0
450
400
Power Point Excel
325
275
200
Word
350
525 600
800
375 1000
1200
1400
1600
Sales in $ Mn
9 Pattern Mania - Green - 1
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
1250
1500
Sales in $ Mn
10 Pattern Mania - Green - 2
Sample Chart 1600
n
1400 1200
375 325
1750
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
450
400 350
400
300
200
100
125
175
200
2003
2004
0
525
250
200
170
Outlook Word Power Point
275
250
300
350
2005
2006
2007
Excel
Years
11 Pattern Mania - Yellow - 2
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
525
250
450
400 350
275
300
200
100
125
175
200
250
300
350
2003
2004
2005
2006
2007
0
170
Word Power Point
400
200
Outlook
Excel
Years
12 Pattern Mania - Orange - 2
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
400 350
400
300
200
100
125
175
200
2003
2004
0
525
250
170
450 200
Outlook Word Power Point
275
250
300
350
2005
2006
2007
Excel
Years
13 Very very light - 1
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600 300
525
250 400 350
450
Outlook Word Power Point
275
Excel
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
200
2003
2004
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
250
300
350
2005
2006
2007
Years
14 Dark Lord - 1
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
250
275
400
300
200
100 175
0
350
2003
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
200
250
300
350
2004
2005
2006
2007
Years
15 Dark Lord - 2
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word
350
Power Point Excel
2 006
300
2 007
200
350
0
450
275
250
500
325
525
750
375
1000
1250
1500
1750
Sales in $ Mn
16 Dark Lord - 3
Sample Chart
Sales in $ Mn
1500 375
1250 325
1000 750 500 250 0
350 275 300
250 400 350 170
525 450 200
Outlook Word Power Point
275
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Excel
Sales in $ Mn
375
1250 325
1000
350
750
275
500
400
100 175
125
2003
2004
250 0
Power Point Excel
275
200
170 250
300
350
2005
2006
2007
200
Word
450
350
300
Outlook
525
250
Years
17 Dark Lord - 4
Sample Chart 2 003
175
2 004
100
200
300
275
125
350
250 Outlook
2 Years 005
250
170
400
Word
350
Power Point Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
18 Wheat Field
Sample Chart
Sales in $ Mn
1500 375
1250 325
1000
350
750
275
500 250 0
Word
450
400 350
300
Outlook
525
250
Power Point
170
Excel
275
200
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
19 Rainbow - 1
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word Power Point
350
Excel
2 006
300
2 007
200
350
0
450
275
250
500
325
525
750
375
1000
Sales in $ Mn
1250
1500
1750
005
Power Point Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
20 Rainbow - 2
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word Power Point
350
Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
21 Outline - 1
Sample Chart 2 003
175
2 004
300
100
200
275
350
125
250 Outlook
2 Years 005
250
2 006
300
2 007
350 450
200
350
0
400
170
500
Power Point Excel
325 525
275
250
Word
750
375
1000
1250
1500
1750
Sales in $ Mn
22 Outline - 2
Sample Chart Sales in $ Mn
1500 375
1250 325
1000 750 500 250 0
350 275 300
250 400 350
100 175
125
2003
2004
200
170
525 450 200
Word Power Point
275
250
300
350
2005
2006
2007
Years
Outlook
Excel
[This is book 2 - see book 1 and 3 as well]
end / 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 bottom
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 th 6 Now, watch out as your charts start stealing all eyes in boardroom
io button (towards bottom left)
ou can remember
r-defined-charts library n on tool bar, and select the chart type as custom -> user defined ->your chart name
73 Free Designer Quality Excel Chart / Graph Templates
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / mo
3. Pie Charts (22 templates, scroll down for more) 1 Grey-scale
2 Orange Parade
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
3 Blue Lagoon
Word 525
4 Red Red Roses
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
5 Green Meadows
Word 525
6 Another Blue
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
Word 525
Power Point 275
Power Point 275 Word 525
7 Pattern Mania - Green - 1
Sample Chart
Excel 350
Outlook 375
Word 525
8 Pattern Mania - Green - 2
Sample Chart
Excel 350
Power Point 275
Power Point 275
Word 525
Word 525
9 Pattern Mania - Yellow - 1
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
10 Pattern Mania - Yellow - 2
Sample Chart
Excel 350
Power Point 275 Word 525
11 Pattern Mania - Orange - 1
Sample Chart
Excel 350
Outlook 375
Power Point 275
Word 525
12 Pattern Mania - Orange - 2
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
13 On a pink day
Outlook 375
Word 525
14 Very very light - 1
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
15 On a rainy day
Word 525
16 Dark Lord - 1
Sample Chart
Excel 350
Outlook 375
Sample Chart
Excel 350
Word 525
17 Dark Lord - 2
Word 525
18 Dark Lord - 4
Sample Chart
Outlook 375
Sample Chart
Excel 350
Outlook 375
Power Point 275
Power Point 275
Word 525
Word 525
19 Rainbow - 1
20 Rainbow - 2
Sample Chart
Excel 350
Outlook 375
Power Point 275
Power Point 275
Excel 350
Outlook 375
Outlook 375
Sample Chart
Excel 350
Outlook 375
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
21 Outline - 1
Word 525
22 Outline - 2
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
Word 525
[This is book 3 - see book 1 and 2 also]
end / 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 about 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 bottom
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 th 6 Now, watch out as your charts start stealing all eyes in boardroom
io button (towards bottom left)
ou can remember
r-defined-charts library n on tool bar, and select the chart type as custom -> user defined ->your chart name
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / m
1. Column / Bar Charts (29 templates, scroll down to see more) 1 Grey-scale
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525
$450 $400 $350
$350
$300
$275
$250 $200 $175
$350 $325
$300
$375
2005
$200 $170
2006 2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
2 Orange Parade
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $275
$250 $200 $175
$375 $350 $325
$350
$300
$300
$275 $250
2004 2005 2006
$200 $170
2007
$125 $100
Excel
2003
Power Point
Word
Outlook
Products
3 Blue Lagoon
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2005
$200 $170
2006 2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
4 Red Red Roses
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2005 2006
$200 $170
2007
$125 $100
Excel
2003 2004
$275 $250
Power Point
Word
Outlook
Products
5 Green Meadows
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word
Outlook
Products
6 Another Blue
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
2003 2004
$275 $250
2005 2006
$200 $170
2007
$125 $100
Excel
Power Point
Word
Outlook
Products
7 Pattern Mania - Grey
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$275
$250 $200 $175
$375 $350 $325
$350
$300
$300
$275 $250
2004 2005 2006
$200 $170 $125 $100
$100
2003
2007
$Excel
Power Point
Word
Outlook
Products
8 Pattern Mania - Blue
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
2004 2005 2006
$200 $170 $125 $100
$100
2003
2007
$Excel
Power Point
Word
Outlook
Products
9 Pattern Mania - Green - 1
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
$Excel
2004 2005 2006 2007
$125 $100
$100
2003
Power Point Products
Word
Outlook
$525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
2003 2004 2005 2006
$200 $170
2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
10 Pattern Mania - Green - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $175
$375 $350 $325
$350
$200
$300
2005 2006
$200 $170 $100
Excel
2003 2004
$275 $250
2007
$125
Power Point
Word
Outlook
Products
11 Pattern Mania - Yellow - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $175
$375 $350 $325
$350
$200
$300
2005 2006
$200 $170 $100
Excel
2003 2004
$275 $250
2007
$125
Power Point
Word
Outlook
Products
12 Pattern Mania - Yellow - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$300
$350
$375 $325
$275 $250
$200
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales in $ Mn
$450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$350
$300
$375 $325
2003 2004
$275 $250
2005
$200
2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
13 Pattern Mania - Orange - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$170
$350
$300
$375 $325
2003 2004
$275 $250
2005
$200
2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
14 Pattern Mania - Orange - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$350
$300
$275
$375 $325
$250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
15 On a pink day
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400 $300 $200
$350 $300 $250 $200 $175
$100
$350 $275
$300
$375 $350 $325 $275 $250
$200 $170 $125 $100
2004 2005 2006 2007
$Excel
2003
Power Point Products
Word
Outlook
Sales in $ M
$400
$400
$350 $300
$300 $200
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170 $125 $100
$100
2003 2004 2005 2006 2007
$Excel
Power Point
Word
Outlook
Products
16 Very very light - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
17 On a rainy day
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
18 Dark Lord - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$275 $250
$200 $170 $100
Excel
$300
$375 $350 $325
2003 2004 2005 2006 2007
$125
Power Point Products
Word
Outlook
Sales in $
$350 $300 $250 $200 $150 $100 $50 $-
$350
$350
$300
$275
$250 $200 $175
$350 $325
$300
$275 $250
$200 $170 $100
Excel
2003 2004 2005 2006 2007
$125
Power Point
Word
Outlook
Products
19 Dark Lord - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2003
2006 2007
$125
Power Point
Word
Outlook
Products
20 Dark Lord - 3
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2003
2006 2007
$125
Power Point
Word
Outlook
Products
21 Dark Lord - 4
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$300
$275
$250
$200 $170 $100
Excel
$375 $350 $325
$350
2003 2004 2005 2006 2007
$125
Power Point Products
Word
Outlook
Sales in
$300 $250 $200 $150 $100 $50 $-
$300
$275
$250 $200 $175
$300
$275
2004
$250
2005
$200 $170 $100
Excel
2006 2007
$125
Power Point
Word
Outlook
Products
22 Wheat Field
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$375 $350 $325
$350
$300
$275
$250 $200 $175
$300
2005
$200 $170 $100
Excel
2003 2004
$275 $250
2006 2007
$125
Power Point
Word
Outlook
Products
23 Rainbow - 1
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
24 Rainbow - 2
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350
$350
$300
$275
$250 $200 $175
$300
$375 $350 $325 $275 $250
$200 $170
2004 2005 2006 2007
$125 $100
Excel
2003
Power Point
Word Products
Outlook
Sales i
$250 $200 $150 $100 $50 $-
$250
$250
$200 $175
$200 $170
2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
25 Lavender Love
Sales in $ Mn
Sample Chart $550 $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $-
$525 $450 $400 $350 $300
$275
$250 $200 $175
$375 $350 $325
$350 $300
$275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
Excel
Power Point
Word
Outlook
Products
26 Outline - 1
Sample Chart $600
$525
Sales in $ Mn
$500
$450 $400
$400
$350 $300 $250
$300 $200
$200 $175
$275
$350 $300
$375 $350 $325 $275 $250
$200 $170
2003 2004 2005 2006 2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
27 Outline - 2
Sample Chart $600
$525
Sales in $ Mn
$500 $400 $300 $200
$450 $400 $350 $300 $250 $200 $175
$275
$350 $300
$375 $350 $325 $275 $250
$200 $170
Power Point Products
2005 2007
$Excel
2004 2006
$125 $100
$100
2003
Word
Outlook
Sal
$200
$200 $170
$200 $175
2006 2007
$125 $100
$100 $Excel
Power Point
Word
Outlook
Products
28 Pseudo Incell
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350 $300
$300 $200
$350 $275
$250 $175
$200
$170 $100
$100
$350
$300
$275
$375 $325
2003 2004 2005
$250
2006
$200
2007
$125
$Excel
Power Point
Word
Outlook
Products
29 Trance - Equalizer
Sample Chart $600 $525
Sales in $ Mn
$500
$450 $400
$400
$350
$300 $200
$350
$300
$275
$250 $175
$200
$170 $100
$100
$300
$350 $275
$375 $325
$250
$200
2004 2005 2006 2007
$125
$Excel
2003
Power Point Products
Word
Outlook
[This is book 1 - see book 2 and 3 also]
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
Sales (in 2005 2006 $250 $300 $170 $200 $400 $450 $350 $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
73 Free Designer Quality Excel Chart / Graph Templates
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / mo
2. Stacked Charts / Graphs (22 templates, scroll down for more) 1 Grey-scale
Sample Chart 1750
Sales in $ Mn
1500 375
1250 1000
325
350
750
250
275
500 250 0
100 175
125
2003
2004
Power Point Excel
275
200
170
200
Word
450
400
350
300
Outlook
525
250
300
350
2005
2006
2007
Products
2 Orange Parade
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
1250
1500
1750
Sales in $ Mn
3 Blue Lagoon
Sample Chart 1750
Sales in $ Mn
1500 375
1250 1000 750 500 250 0
350 275 300
250 350
400 170
325
Outlook
525
200
Excel
275
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
Word Power Point
450
Sal
500 250 0
400
350
300
Excel
275
200
170
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
4 Red Red Roses
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
400
200
350
2007
0
450
Power Point Excel
325
275 250
Word
350
525
500
750
375 1000
1250
1500
1750
Sales in $ Mn
5 Green Meadows
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
200
2003
2004
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
250
300
350
2005
2006
2007
Years
6 Another Blue
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
Sales in $ Mn
1250
1500
1750
7 Pattern Mania - Grey
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
2003
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
200
250
300
350
2004
2005
2006
2007
Years
8 Pattern Mania - Blue
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
400 200
350
2007
0
450
400
Power Point Excel
325
275
200
Word
350
525 600
800
375 1000
1200
1400
1600
Sales in $ Mn
9 Pattern Mania - Green - 1
Sample Chart 175
2003
100
200
2004
300
125
275 350
250 Outlook
Years2005
250
170
300
2006
200
350
2007
0
400 450 275
250
500
Word
350
Power Point Excel
325 525
750
375 1000
1250
1500
Sales in $ Mn
10 Pattern Mania - Green - 2
Sample Chart 1600
n
1400 1200
375 325
1750
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
450
400 350
400
300
200
100
125
175
200
2003
2004
0
525
250
200
170
Outlook Word Power Point
275
250
300
350
2005
2006
2007
Excel
Years
11 Pattern Mania - Yellow - 2
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
525
250
450
400 350
275
300
200
100
125
175
200
250
300
350
2003
2004
2005
2006
2007
0
170
Word Power Point
400
200
Outlook
Excel
Years
12 Pattern Mania - Orange - 2
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600
400 350
400
300
200
100
125
175
200
2003
2004
0
525
250
170
450 200
Outlook Word Power Point
275
250
300
350
2005
2006
2007
Excel
Years
13 Very very light - 1
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000 800
350 275
600 300
525
250 400 350
450
Outlook Word Power Point
275
Excel
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
275
400
300
200
100 175
0
350
200
2003
2004
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
250
250
300
350
2005
2006
2007
Years
14 Dark Lord - 1
Sample Chart 1600
Sales in $ Mn
1400
375
1200
325
1000
350
800
250
275
400
300
200
100 175
0
350
2003
Power Point Excel
275
200
170
125
Word
450
400
600
Outlook
525
200
250
300
350
2004
2005
2006
2007
Years
15 Dark Lord - 2
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word
350
Power Point Excel
2 006
300
2 007
200
350
0
450
275
250
500
325
525
750
375
1000
1250
1500
1750
Sales in $ Mn
16 Dark Lord - 3
Sample Chart
Sales in $ Mn
1500 375
1250 325
1000 750 500 250 0
350 275 300
250 400 350 170
525 450 200
Outlook Word Power Point
275
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Excel
Sales in $ Mn
375
1250 325
1000
350
750
275
500
400
100 175
125
2003
2004
250 0
Power Point Excel
275
200
170 250
300
350
2005
2006
2007
200
Word
450
350
300
Outlook
525
250
Years
17 Dark Lord - 4
Sample Chart 2 003
175
2 004
100
200
300
275
125
350
250 Outlook
2 Years 005
250
170
400
Word
350
Power Point Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
18 Wheat Field
Sample Chart
Sales in $ Mn
1500 375
1250 325
1000
350
750
275
500 250 0
Word
450
400 350
300
Outlook
525
250
Power Point
170
Excel
275
200
100 175
125 200
250
300
350
2003
2004
2005
2006
2007
Years
19 Rainbow - 1
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word Power Point
350
Excel
2 006
300
2 007
200
350
0
450
275
250
500
325
525
750
375
1000
Sales in $ Mn
1250
1500
1750
005
Power Point Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
20 Rainbow - 2
Sample Chart 2 003
175
2 004
100
200
300
125
275
350
250 Outlook
2 Years 005
250
170
400
Word Power Point
350
Excel
2 006
300
2 007
200
350
0
450
325
275
250
525
500
750
375
1000
1250
1500
1750
Sales in $ Mn
21 Outline - 1
Sample Chart 2 003
175
2 004
300
100
200
275
350
125
250 Outlook
2 Years 005
250
2 006
300
2 007
350 450
200
350
0
400
170
500
Power Point Excel
325 525
275
250
Word
750
375
1000
1250
1500
1750
Sales in $ Mn
22 Outline - 2
Sample Chart Sales in $ Mn
1500 375
1250 325
1000 750 500 250 0
350 275 300
250 400 350
100 175
125
2003
2004
200
170
525 450 200
Word Power Point
275
250
300
350
2005
2006
2007
Years
Outlook
Excel
[This is book 2 - see book 1 and 3 as well]
end / 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 bottom
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 th 6 Now, watch out as your charts start stealing all eyes in boardroom
io button (towards bottom left)
ou can remember
r-defined-charts library n on tool bar, and select the chart type as custom -> user defined ->your chart name
73 Free Designer Quality Excel Chart / Graph Templates
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / mo
3. Pie Charts (22 templates, scroll down for more) 1 Grey-scale
2 Orange Parade
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
3 Blue Lagoon
Word 525
4 Red Red Roses
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
5 Green Meadows
Word 525
6 Another Blue
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
Word 525
Power Point 275
Power Point 275 Word 525
7 Pattern Mania - Green - 1
Sample Chart
Excel 350
Outlook 375
Word 525
8 Pattern Mania - Green - 2
Sample Chart
Excel 350
Power Point 275
Power Point 275
Word 525
Word 525
9 Pattern Mania - Yellow - 1
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
10 Pattern Mania - Yellow - 2
Sample Chart
Excel 350
Power Point 275 Word 525
11 Pattern Mania - Orange - 1
Sample Chart
Excel 350
Outlook 375
Power Point 275
Word 525
12 Pattern Mania - Orange - 2
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
13 On a pink day
Outlook 375
Word 525
14 Very very light - 1
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
15 On a rainy day
Word 525
16 Dark Lord - 1
Sample Chart
Excel 350
Outlook 375
Sample Chart
Excel 350
Word 525
17 Dark Lord - 2
Word 525
18 Dark Lord - 4
Sample Chart
Outlook 375
Sample Chart
Excel 350
Outlook 375
Power Point 275
Power Point 275
Word 525
Word 525
19 Rainbow - 1
20 Rainbow - 2
Sample Chart
Excel 350
Outlook 375
Power Point 275
Power Point 275
Excel 350
Outlook 375
Outlook 375
Sample Chart
Excel 350
Outlook 375
Sample Chart
Excel 350
Outlook 375
Power Point 275
Sample Chart
Excel 350
Power Point 275 Word 525
21 Outline - 1
Word 525
22 Outline - 2
Sample Chart
Excel 350
Outlook 375
Outlook 375
Power Point 275
Sample Chart
Excel 350
Outlook 375
Power Point 275 Word 525
Word 525
[This is book 3 - see book 1 and 2 also]
end / 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 about 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 bottom
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 th 6 Now, watch out as your charts start stealing all eyes in boardroom
io button (towards bottom left)
ou can remember
r-defined-charts library n on tool bar, and select the chart type as custom -> user defined ->your chart name
Related Documents
73 Designed Quality Excel Chart Templates
December 2019 5
73 Free Designed Quality Excel Chart Templates - 2
October 2019 3
Templates
December 2019 48
Quality Control Chart Sampling)
May 2020 16
Templates
July 2020 40
Quality Control Chart (variable Samples)
May 2020 15More Documents from "SpreadsheetZONE"
Very Good Presentation
December 2019 17
To Do List
December 2019 15
Swing Trading Calculator
October 2019 20
Cover Letters From Mit
October 2019 16
Cover Letter 5
October 2019 22