73 designed quality excel chart templates
DESCRIPTION
73 Designed Quality Excel Chart TemplatesTRANSCRIPT
73 Free Designer Quality Excel Chart / Graph Templates
1. Column / Bar Charts (29 templates, scroll down to see more)
1 Grey-scale
2 Orange Parade
3 Blue Lagoon
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / modify as you like
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
4 Red Red Roses
5 Green Meadows
6 Another Blue
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
7 Pattern Mania - Grey
8 Pattern Mania - Blue
9 Pattern Mania - Green - 1
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325
$350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
10 Pattern Mania - Green - 2
11 Pattern Mania - Yellow - 1
12 Pattern Mania - Yellow - 2
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
13 Pattern Mania - Orange - 1
14 Pattern Mania - Orange - 2
15 On a pink day
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
16 Very very light - 1
17 On a rainy day
18 Dark Lord - 1
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
19 Dark Lord - 2
20 Dark Lord - 3
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
21 Dark Lord - 4
22 Wheat Field
23 Rainbow - 1
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
24 Rainbow - 2
25 Lavender Love
26 Outline - 1
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
27 Outline - 2
28 Pseudo Incell
29 Trance - Equalizer
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007ProductsS
ale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
[This is book 1 - see book 2 and 3 also]
Data used:
Sales (in mn $)Product Code 2003 2004 2005 2006 2007Excel $ 175 $ 200 $ 250 $ 300 $ 350 Power Point $ 100 $ 125 $ 170 $ 200 $ 275 Word $ 300 $ 350 $ 400 $ 450 $ 525 Outlook $ 275 $ 250 $ 350 $ 325 $ 375
How to use these templates?
Method 1 : Simple and fast
1 Copy the chart you wanted and the data used portion above2 Paste in your workbook3 Change the values, remove columns (or add them if you wish)4 Modify formatting if needed5 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 left)
- Feel free to share / extend / mail / save / modify as you like
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
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 library5 In future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name6 Now, watch out as your charts start stealing all eyes in boardroom
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325
$350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$1
75
$1
00
$3
00
$2
75
$2
00
$1
25
$3
50
$2
50
$2
50
$1
70
$4
00
$3
50
$3
00
$2
00
$4
50
$3
25
$3
50
$2
75
$5
25
$3
75
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
Excel Power Point Word Outlook
$-
$100
$200
$300
$400
$500
$600
$175
$100
$300 $275
$200
$125
$350
$250 $250
$170
$400
$350
$300
$200
$450
$325 $350
$275
$525
$375
Sample Chart
2003 2004 2005 2006 2007Products
Sale
s i
n $
Mn
In the dailog, go to "custom types" tab and select "User-defined" radio button (towards bottom left)
Click on "Add…" button, and give your chart-template a name that you can remember
When you are done, click ok, and the chart is now added to your user-defined-charts libraryIn future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name
73 Free Designer Quality Excel Chart / Graph Templates
2. Stacked Charts / Graphs (22 templates, scroll down for more)
1 Grey-scale
2 Orange Parade
3 Blue Lagoon
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / modify as you like
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelProducts
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
4 Red Red Roses
5 Green Meadows
6 Another Blue
7 Pattern Mania - Grey
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
8 Pattern Mania - Blue
9 Pattern Mania - Green - 1
10 Pattern Mania - Green - 2
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
11 Pattern Mania - Yellow - 2
12 Pattern Mania - Orange - 2
13 Very very light - 1
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
14 Dark Lord - 1
15 Dark Lord - 2
16 Dark Lord - 3
17 Dark Lord - 4
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
18 Wheat Field
19 Rainbow - 1
20 Rainbow - 2
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
21 Outline - 1
22 Outline - 2
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
[This is book 2 - see book 1 and 3 as well]
Data used:
Sales (in mn $)Product Code 2003 2004 2005 2006 2007Excel $ 175 $ 200 $ 250 $ 300 $ 350 Power Point $ 100 $ 125 $ 170 $ 200 $ 275 Word $ 300 $ 350 $ 400 $ 450 $ 525 Outlook $ 275 $ 250 $ 350 $ 325 $ 375
How to use these templates?
Method 1 : Simple and fast
1 Copy the chart you wanted and the data used portion above2 Paste in your workbook3 Change the values, remove columns (or add them if you wish)4 Modify formatting if needed5 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 left)
- Feel free to share / extend / mail / save / modify as you like
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelProducts
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
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 library5 In future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name6 Now, watch out as your charts start stealing all eyes in boardroom
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
1800
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300
350400
450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125170
200275
300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003
2004
2005
2006
2007
0 200 400 600 800 1000 1200 1400 1600 1800
175
200
250
300
350
100
125
170
200
275
300
350
400
450
525
275
250
350
325
375
Sample Chart
Excel Power Point Word OutlookSales in $ Mn
Years
2003 2004 2005 2006 2007
0
200
400
600
800
1000
1200
1400
1600
175 200 250 300 350100 125
170200
275300350
400450
525
275250
350325
375
Sample Chart
Outlook Word Power Point ExcelYears
Sale
s i
n $
Mn
In the dailog, go to "custom types" tab and select "User-defined" radio button (towards bottom left)
Click on "Add…" button, and give your chart-template a name that you can remember
When you are done, click ok, and the chart is now added to your user-defined-charts libraryIn future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name
73 Free Designer Quality Excel Chart / Graph Templates
3. Pie Charts (22 templates, scroll down for more)
1 Grey-scale 2 Orange Parade
3 Blue Lagoon 4 Red Red Roses
5 Green Meadows 6 Another Blue
Created by http://chandoo.org/wp - Point Haired Dilbert - Feel free to share / extend / mail / save / modify as you like
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
7
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
7 Pattern Mania - Green - 1 8 Pattern Mania - Green - 2
9 Pattern Mania - Yellow - 1 10 Pattern Mania - Yellow - 2
11 Pattern Mania - Orange - 1 12 Pattern Mania - Orange - 2
13 On a pink day 14 Very very light - 1
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
15 On a rainy day 16 Dark Lord - 1
17 Dark Lord - 2 18 Dark Lord - 4
19 Rainbow - 1 20 Rainbow - 2
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
21 Outline - 1 22 Outline - 2
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
[This is book 3 - see book 1 and 2 also]
Data used:
Sales (in mn $)Product Code 2003 2004 2005 2006 2007Excel $ 175 $ 200 $ 250 $ 300 $ 350 Power Point $ 100 $ 125 $ 170 $ 200 $ 275 Word $ 300 $ 350 $ 400 $ 450 $ 525 Outlook $ 275 $ 250 $ 350 $ 325 $ 375
How to use these templates?
Method 1 : Simple and fast
1 Copy the chart you wanted and the data used portion above2 Paste in your workbook3 Change the values, remove columns (or add them if you wish)4 Modify formatting if needed5 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 left)
- Feel free to share / extend / mail / save / modify as you like
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 library5 In future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name6 Now, watch out as your charts start stealing all eyes in boardroom
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Excel; 350
Power Point; 275
Word; 525
Outlook; 375
Sample Chart
Be careful now, as your boss may feel zealous about your charting skills
In the dailog, go to "custom types" tab and select "User-defined" radio button (towards bottom left)
Click on "Add…" button, and give your chart-template a name that you can remember
When you are done, click ok, and the chart is now added to your user-defined-charts libraryIn future, when you want to use the chart, simply click on charts icon on tool bar, and select the chart type as custom -> user defined ->your chart name