國(guó)際知名咨詢公司的圖表大全(IV)

《國(guó)際知名咨詢公司的圖表大全(IV)》由會(huì)員分享，可在線閱讀，更多相關(guān)《國(guó)際知名咨詢公司的圖表大全(IV)（56頁珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

1、Templates Graphs US Business Group General rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot and bubble graphs Presenter/timingAgenda Create graphs using the native PowerPoint ch

2、art software, rather than pasting graphs from ExcelParticipation in Harley Davidson conventions, 1998-2002Thousands of people CAGR1998-2002 68% 4 7 16 25 32 0 5 10 15 20 25 30 35 1998 1999 2000 2001 2002E Title is bold, with the time period appearing after a comma. Always write out the year in full.

3、 The optional subtitle provides additional info on the data and is not bold, italics, 2 points smaller than the title. Line spacing is 1 Axis titles are optional and should not be used if the information is given elsewhere or is self-evident The CAGR block should be placed to the right of the graph.

4、 Font size should be close to that the graphs data labelsIn general, use whole numbers unless you have a specific reason for including decimalsWhen the data refers to projected or estimated figures, add “E” to the year labelWhen used, axis tick marks should be placed on the outside of the axisRememb

5、er to adjust the document title tracker when you create a new document. It should match the name of the PowerPoint file In general, include all relevant information while keeping the graph as simple as possible Cumulative number of Rhodes Scholars, 1900-1980Harvard vs. Yale 4 7 16 25 32 2 8 20 50 99

6、 0 20 40 60 80 100 120 1900 1920 1940 1960 1980 Yale HarvardAll numbers in the graph (data and axis labels) should be the same size. Text labels may be smaller if necessary Do not add unit symbols (e.g., $ or M) to the axis labels (except for %).Set the intervals to the largest reasonable value poss

7、ible In general, do not use borders on bars, columns, pie pieces, et ceteraIf a legend is needed, place it to the right of the graph or within the plot area. Do not add a border and set the font to roughly the same size as the data labels l If resizing graphs in the main PowerPoint application, make

8、 sure to use only the corner object boxes (see diagram)l Make sure that the graph is resized with the same aspect ratio (vertical/horizontal proportions)l If the text becomes distorted, undo immediately! The safest way to change the size or position of graph elements is to do so within the native gr

9、aph application itself4 7 16 25 3205101520253035 1995 1996 1997 1998E 1999EUse the corner object boxes only when resizing graphs! It is also advisable to hold down the key when doing so Be careful when resizing graphs! When choosing colors for adjacent graph elements, be sure to alternate light and

10、dark colors (examples from the color palette shown below):Growth in color bars, 1990-2000Millions of Pixels 1 3 4 If you want to insert a callout, use this type of text box, not the yellow ones used in this document for editorial commentsIf a given data element is too small to fit a data label, plac

11、e the label outside in a separate text box Try to use colors from the main color palette as muchas possible Select from the palette shown below for box fills, graphs, shadows, and other color elementsFillR-0G-52B-102 AccentR-239G-196B-089 Accent 2R-040G-108B-026 Accent 3R-255G-245B-200 Title TextR-2

12、22G-029B-014 ShadowR-153G-153B-153 R-204G-204B-153 R-073G-133B-163 R-67G-67B-148Additional colors, if neededR-255G-254B-243 General rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter p

13、lot and bubble graphs Presenter/timingAgenda Bar graph, 1 data seriesTitle, time periodSubtitle 6 10 7 24 15 0 5 10 15 20 25 30 Category A Category B Category C Category D Category E Axis title Axis title Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should e

14、nd in a period. Bar graph, 2 data series 6 10 7 24 15 6 10 7 24 15 0 5 10 15 20 25 30 Category A Category B Category C Category D Category E Dataset 1 Dataset 2 Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAx

15、is title Axis title Bar graph, 12 categories 6 10 7 24 15 13 7 8 10 4 22 28 0 5 10 15 20 25 30 Category A Category B Category C Category D Category E Category F Category G Category H Category I Category J Category K Category LSource: Text is Arial, 8-point, plain; a semicolon should separate each it

16、em; the line should end in a period. Title, time periodSubtitleAxis title Axis title Stacked bar graph 6 10 10 24 15 6 10 10 24 15 3 5 7 12 8 5 7 9 14 10 1 3 4 10 6 0 10 20 30 40 50 60 70 80 90 Category A Category B Category C Category D Category E Dataset 1Dataset 2 Dataset 3Dataset 4 Dataset 5 21

17、35 40 8454 Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. When necessary, give the total for the column in a separate boxTitle, time periodSubtitleAxis title Axis title 100% stacked bar graph 6 10 10 24 15 6 10 10 24 15 3 5 7 12 8 5 7 9

18、 14 10 1 3 4 10 6 0% 20% 40% 60% 80% 100% Category A Category B Category C Category D Category E Dataset 1Dataset 2 Dataset 3Dataset 4 Dataset 5 Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. These “series lines” are optional and can be

19、 turned on and off under “Format Data Series/Options”Title, time periodSubtitleAxis title Axis title Column graph, 1 data series CAGR1998-2002xx% 4 7 16 25 32 0 5 10 15 20 25 30 35 1998 1999 2000 2001 2002ESource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should

20、end in a period. Title, time periodSubtitleAxis title Axis title Column graph, 2 data series 4 7 16 25 32 8 14 32 50 64 0 10 20 30 40 50 60 70 Category A Category B Category C Category D Category E Column 1 Column 2 Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the li

21、ne should end in a period. Title, time periodSubtitleAxis title Axis title Column graph, 2 data series, 15 categories 4 7 16 25 32 4 6 18 23 12 11 5 3 17 98 14 32 50 64 8 12 36 46 24 22 10 6 34 18 0 10 20 30 40 50 60 70 Cate gory A Cate gory B Cate gory C Cate gory D Cate gory E Cate gory F Cate gor

22、y G Cate gory H Cate gory I Cate gory J Cate gory K Cate gory L Cate gory M Cate gory N Cate gory O Column 1 Column 2 Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis title Stacked column graph 6

23、10 10 15 246 10 10 15 24 3 5 7 8 12 5 7 9 10 14 1 3 4 6 10 0 10 20 30 40 50 60 70 80 90 Category A Category B Category C Category D Category E Dataset 5 Dataset 4 Dataset 3 Dataset 2 Dataset 1 21 35 40 8454 CAGRCategories A-Exx%xx%xx%xx%xx%xx% Source: Text is Arial, 8-point, plain; a semicolon shoul

24、d separate each item; the line should end in a period. TotalTitle, time periodSubtitleAxis title Axis title CAGRCategories A-Exx%xx%xx%xx% xx%Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis title

25、6 10 10 15 246 10 10 15 243 5 7 8 125 7 9 10 14 1 3 4 6 10 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Category A Category B Category C Category D Category E Dataset 5 Dataset 4 Dataset 3 Dataset 2 Dataset 1 100% stacked column graph Waterfall chart, single step 20 20 20 20 20 20 20 140 0 20 40 60 8

26、0 100 120 140 A B C D E F G HSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis title Waterfall chart, double step 20 20 20 20 20 20 20 140140 0 20 40 60 80 100 120 140 A B C D E F G H ISource: Text

27、 is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis title Half-size bar and column graphs 4 7 16 25 32 0 5 10 15 20 25 30 35 1998 1999 2000 2001 2002E 16 32 7 25 18 0 5 10 15 20 25 30 35 Category A Category B Ca

28、tegory C Category D Category ESource: (a) source for first graph; (b) source for second graph. Title, time periodSubtitleAxis title Axis title Title, time periodSubtitleAxis title Axis title Half-size stacked column graphs Source: (a) Source for first graph; (b) Source for second graph. 6 10 10 6 10

29、 10 3 5 7 5 7 9 3 41 0% 20% 40% 60% 80% 100% Category A Category B Category C Dataset 5 Dataset 4 Dataset 3 Dataset 2 Dataset 1 6 10 10 6 10 103 5 7 5 7 9 3 4 1 0 5 10 15 20 25 30 35 40 45 Category A Category B Category C Dataset 5 Dataset 4 Dataset 3 Dataset 2 Dataset 1 Title, time periodSubtitleAx

30、is title Axis title Title, time periodSubtitleAxis title Axis title Half-size waterfall charts 20 20 20 20 20 100 0 20 40 60 80 100 A B C D E FSource: (a) Source for first graph; (b) Source for second graph. Title, time periodSubtitleAxis title Axis title Title, time periodSubtitleAxis Title Axis ti

31、tle20 20 20 20 20100020406080 100 A B C D E F One-third-size bar and column graphsAxis title Axis title Source: (a) Source for first graph; (b) Source for second graph; (c) Source for third graph. 16 32 7 25 18 0 10 20 30 40 A B C D E Axis title 4 7 16 25 32 0 5 10 15 20 25 30 35 1998 1999 2000 2001

32、 2002E 15 7 12 25 21 0 5 10 15 20 25 30 1998 1999 2000 2001 2002EAxis title Axis titleAxis title Title, time periodaSubtitle Title, time periodcSubtitleTitle, time periodbSubtitle One-third-size waterfall and stacked column graphsAxis title Axis titleSource: (a) Source for first graph; (b) Source fo

33、r second graph; (c) Source for third graph.20 20 20 20 20100020406080100 A B C D E F 10 1010 105 77 93 4051015202530354045 Category A Category B 10 1010 105 77 93 40%20%40%60%80%100% Category A Category B Title, time periodaSubtitle Title, time periodcSubtitleTitle, time periodbSubtitleAxis title Ax

34、is title Axis title Axis title Tornado chart: back-to-back bar graphs Axis titleSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.151821242628 0102030 Category ACategory BCategory CCategory DCategory F Axis titleCategory E 15 18 21 24 26 28

35、0 10 20 30 Title, time periodSubtitle Tornado chart: horizontal stacked chart Axis titleSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.0.860.78 0.60 0.38 0.180.120.040.16 0.840.500.60 1.060.210.18 0.350.240.0 0.5 1.0 1.5 2.0 2.5 3.0Categ

36、ory ACategory BCategory CCategory DCategory ECategory FCategory GCategory H Title, time periodSubtitle General rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot and bubble graphs

37、 Presenter/timingAgenda Basic line graph 0 50 100 150 200 250 300 350 1996 1997 1998 1999 2000 2001 2002E 2003E Worldwide United States CAGR1996-2003xx%xx% Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Datapoint markers are 5 points in

38、 size Title, time periodSubtitle Basic line graph with data labels Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.38 69 97 132 170 320 39 52 67 84 107 136 228 14 23 100 50 100 150 200 250 300 350 1996 1997 1998 1999 2000 2001 2002E 2003E

39、 Worldwide United States CAGR1996-2003xx%xx%Title, time periodSubtitle Multi-line graph with CAGR Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Axis title Axis title 0 5 10 15 20 25 30 1998 1999 2000 2001 2002E Client Competitor 1 Comp

40、etitor 2 Competitor 3 Competitor 4 CAGR1998-2002xx%xx%xx%xx% xx% Title, time periodSubtitle Line graph: dual axis Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Axis title Axis title 0 10 20 30 40 50 East West North South0 10 20 30 40 5

41、0Series A Series B Axis title Title, time periodSubtitle Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Axis title Axis title 0 10 20 30 40 50 East West North South200 220 240 260 280 300Series A Series B Axis title0 The break lines and

42、 the zero marker are added separately Title, time periodSubtitleLine graph: dual axis (with pasted scale break on secondary axis) Combination line and column graph: dual-axis Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Axis title Axi

43、s title 0 10 20 30 40 50 East West North South 0 20 40 60 80 100 120 140 160Series A Series B Title, time periodSubtitle Axis title Half-size line graphsAxis title Axis title Axis title Axis title Title, time periodaSubtitle Title, time periodbSubtitle Axis title 0 50 100 150 200 250 300 350 1997 19

44、98 1999 2000 2001 2002E 2003E 2004E Worldwide United States Source: (a) Source for first graph; (b) Source for second graph. 010 20 30 40 50 East West North South 0 20 40 60 80 100 120 140 160Series A Series B One-third-size line graphs Axis titleAxis titleAxis title Title, time periodcSubtitleTitle

45、, time periodbSubtitleTitle, time periodaSubtitle 0 50 100 150 200 250 300 350 1996 1997 1998 1999 2000 2001 2002E 2003E Worldwide United States 0 20 40 60 80 100 120 1996 1997 1998 1999 2000 2001 2002E 2003E 0 10 20 30 40 50 East West North South 0 20 40 60 80 100 120 140 160Series A Series BAxis t

46、itle Axis title Axis title Axis title Source: (a) Source for first graph; (b) Source for second graph; (c) Source for third graph. Curved line chart (no data) Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title of chartSubtitleAxis tit

47、le Axis title Bell curve chart (no data) Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title of chartSubtitleAxis title Axis title AgendaGeneral rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Pr

48、esenter/timingArea graphs Presenter/timingPie graphs Presenter/timing Scatter plot and bubble graphs Presenter/timing Area graph: data labels inside Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axi

49、s titleClientCompetitor 1Competitor 2Competitor 3020406080100 120 1997 1998 1999 2000 2001 2002E 2003E 2004E Area graph: legend included Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis title02040

50、6080100 120 1997 1998 1999 2000 2001 2002E 2003E 2004E Competitor 3 Competitor 2 Competitor 1 Client 100% stacked area graph Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodSubtitleAxis title Axis titleClientCompetitor

51、1Competitor 2 Competitor 3 0% 20% 40% 60% 80% 100% 1997 1998 1999 2000 2001 2002E 2003E 2004E Half-size area and 100% stacked area graphsAxis title Axis title Axis title Axis title020406080100 120 A B C D E F G H 0% 20% 40% 60% 80% 100% A B C D E F G H Title, time periodaSubtitle Title, time periodb

52、Subtitle ClientCompetitor 1Competitor 2Competitor 3 ClientCompetitor 1Competitor 2 Competitor 3 Source: (a) Source for first graph; (b) Source for second graph. One-third-size area graphsAxis title Title, time periodcSubtitle Axis title Title, time periodbSubtitleTitle, time periodaSubtitle 0 20 40

53、60 80 100 120 A B C D E F G H 0 20 40 60 80 100 120 A B C D E F G H 0% 20% 40% 60% 80% 100% A B C D E F G HSource: (a) Source for first graph; (b) Source for second graph; (c) Source for third graph. ClientCompetitor 1Competitor 2Competitor 3ClientCompetitor 1Competitor 2Competitor 3ClientCompetitor

54、 1Competitor 2Competitor 3 Axis titleAxis title Axis title Axis title General rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot and bubble graphs Presenter/timingAgenda Source: T

55、ext is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Title, time periodTotal = xx million Category A 40% Category B 24% Category C 16% Category D 9% Category E 7% Category F 4% Order the pieces from largest to smallest, unless some other order is appr

56、opriate.In general, the angle of the first slice should be set to zero degreesWhen necessary, place the total figure in the subtitlePie graph: labels on outside Pie graph: labels on inside Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.

57、Title, time periodTotal = xx million Category A 43% Category B 26% Category D 14% Category C 17% The data labels are positioned in the “center” and then moved as needed Half-size pie graphsTitle, time periodaSubtitle Source: (a) Source for first graph; (b) Source for second graph. Title, time period

58、bSubtitle Category A 40% Category B 24% Category C 16% Category D 9% Category E 7% Category F 4% Category A 43% Category B 26% Category D 14% Category C 17% These “l(fā)eader lines” can be set automatically under “Chart Options/Data Labels” Data labels should be either all inside or all outside the pie

59、pieces Half-size pie graphs with separated piece Title, time periodaSubtitle Source: (a) Source for first graph; (b) Source for second graph. Title, time periodbSubtitle Category A 40% Category B 24% Category C 16% Category D 9% Category E 7% Category F 4% Category A 43% Category B 26% Category D 14

60、% Category C 17% Create pie graph as usual, then move out selected piece manually Dual pie-of-pie graphTitle, time periodaSubtitle Category A 38% Category E 9% Category D 13% Category C 17% Category B 23%Source: (a) Source for first graph; (b) Source for second graph. Title, time periodbSubtitle Cat

61、egory W 43% Category X 26% Category Z 14% Category Y 17%To create this graph, enter the data categories in reverse order (so A ends up on the left) and change the angle of first slice so that the piece to be exploded (C) straddles the 90-degree position General rules Presenter/timingBar and column g

62、raphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot and bubble graphs Presenter/timingAgenda Scatter plot with trendlines Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should en

63、d in a period.-20020 40 60 80 100 120 0 10 20 30 40 50 Series A Series B Series C Linear (Series B) Linear (Series A) Poly. (Series C) Title, time periodSubtitleAxis title Axis title Trendlines can be created and modified under the “Chart” menu Scatter plot with four quadrants Title, time periodSubt

64、itle -30% -20% -10% 0% 10% 20% 30% 40% -20% -15% -10% -5% 0% 5% 10% 15% 20% 25% Use white “foreground” on markers to delineate overlapping data points Source: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Complex scatter chart 0 5 10 15 20 25

65、30 35 40 0 1 2 3 4 5 6 7 8 9 Client Competitor 1 Competitor 2 Competitor 3 Title, time periodSubtitleAxis title Axis titleSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period. Bubble graph -5% 0% 5% 10% 15% 20% 25% 0% 5% 10% 15% 20% 25% Title,

66、 time periodaSubtitleAxis Title Axis titleSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.(a) Area of circles reflects xx data. Radar graph 0 30 601998 1999 20002001 2002 Title, time periodaSubtitleAxis title Axis titleSource: Text is Arial, 8-point, plain; a semicolon should separate each item; the line should end in a period.(a) Area of circles reflects xx data.