Chart & Graph
Chart & Graph
Created by [Link] - Point Haired Dilbert - Feel free to share / extend / mail / save / modi
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
2 Orange Parade
Sample Chart
2007 $350 $275 $525 $375
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
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
Sample Chart
2007 $350 $275 $525 $375
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
6 Another Blue
Sample Chart
2007 $350 $275 $525 $375
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
Sample Chart
2007 $350 $275 $525 $375
Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600
Sales in $ Mn Excel Power Point Word Outlook
Sample Chart
2007 $350 $275 $525 $375
Years
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800
Sales in $ Mn Excel Power Point Word Outlook
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
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
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
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
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
15 Dark Lord - 2
Sample Chart
2007 $350 $275 $525 $375
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
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
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
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
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]
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
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