最新国际知名咨询公司的图表大全课件.ppt

1、国际知名咨询公司的图表大国际知名咨询公司的图表大全全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/timingAgendaBar graph,1 data seriesTitle,time periodSubtitle610724

2、15051015202530Category ACategory BCategory CCategory DCategory EAxis titleAxis titleSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Bar graph,2 data series6107241561072415051015202530Category ACategory BCategory CCategory DCategory EDataset 1D

3、ataset 2Source:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleBar graph,12 categories6107241513781042228051015202530Category ACategory BCategory CCategory DCategory ECategory FCategory GCategory HCategory

4、 ICategory JCategory KCategory LSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleStacked bar graph61010241561010241535712857914101341060102030405060708090Category ACategory BCategory CCategory DCateg

5、ory EDataset 1Dataset 2Dataset 3Dataset 4Dataset 52135408454Source: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 titleAxis title100%stacked bar graph6101024

6、1561010241535712857914101341060%20%40%60%80%100%Category ACategory BCategory CCategory DCategory EDataset 1Dataset 2Dataset 3Dataset 4Dataset 5Source: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 turned on

7、 and off under“Format Data Series/Options”Title,time periodSubtitleAxis titleAxis titleColumn graph,1 data seriesCAGR1998-2002xx%471625320510152025303519981999200020012002ESource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtit

8、leAxis titleAxis titleColumn graph,2 data series47162532814325064010203040506070Category ACategory BCategory CCategory D Category EColumn 1Column 2Source:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis title Co

9、lumn graph,2 data series,15 categories47162532461823121153179814325064812364624221063418010203040506070Category ACategory BCategory CCategory DCategory ECategory FCategory GCategory HCategory ICategory JCategory KCategory LCategory MCategory NCategory OColumn 1Column 2Source:Text is Arial,8-point,pl

10、ain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleStacked column graph61010152461010152435781257910141346100102030405060708090Category ACategory BCategory CCategory DCategory EDataset 5Dataset 4Dataset 3Dataset 2Dataset 12135408454

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

12、 line should end in a period.Title,time periodSubtitleAxis titleAxis title61010152461010152435781257910141346100%10%20%30%40%50%60%70%80%90%100%Category ACategory BCategory CCategory DCategory EDataset 5Dataset 4Dataset 3Dataset 2Dataset 1100%stacked column graphWaterfall chart,single step2020202020

13、2020140020406080100120140ABCDEFGHSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleWaterfall chart,double step20202020202020140140020406080100120140ABCDEFGHISource:Text is Arial,8-point,plain;a semico

14、lon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleHalf-size bar and column graphs471625320510152025303519981999200020012002E16327251805101520253035Category ACategory BCategory CCategory DCategory ESource:(a)source for first graph;(b)source for

15、 second graph.Title,time periodSubtitleAxis titleAxis titleTitle,time periodSubtitleAxis titleAxis titleHalf-size stacked column graphsSource:(a)Source for first graph;(b)Source for second graph.61010610103575793410%20%40%60%80%100%Category ACategory BCategory CDataset 5Dataset 4Dataset 3Dataset 2Da

16、taset 16101061010357579341051015202530354045Category ACategory BCategory CDataset 5Dataset 4Dataset 3Dataset 2Dataset 1Title,time periodSubtitleAxis titleAxis titleTitle,time periodSubtitleAxis titleAxis title Half-size waterfall charts2020202020100020406080100ABCDEFSource:(a)Source for first graph;

17、(b)Source for second graph.Title,time periodSubtitleAxis titleAxis titleTitle,time periodSubtitleAxis TitleAxis title2020202020100020406080100ABCDEFOne-third-size bar and column graphsAxis titleAxis titleSource:(a)Source for first graph;(b)Source for second graph;(c)Source for third graph.1632725180

18、10203040ABCDEAxis title471625320510152025303519981999200020012002E15712252105101520253019981999200020012002EAxis titleAxis titleAxis titleTitle,time periodaSubtitleTitle,time periodcSubtitleTitle,time periodbSubtitleOne-third-size waterfall and stacked column graphsAxis titleAxis titleSource:(a)Sour

19、ce for first graph;(b)Source for second graph;(c)Source for third graph.2020202020100020406080100ABCDEF10101010577934051015202530354045Category ACategory B101010105779340%20%40%60%80%100%Category ACategory BTitle,time periodaSubtitleTitle,time periodcSubtitleTitle,time periodbSubtitleAxis titleAxis

20、titleAxis titleAxis titleTornado chart:back-to-back bar graphsAxis titleSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.1518212426280102030Category ACategory BCategory CCategory DCategory FAxis titleCategory E1518212426280102030Title,time peri

21、odSubtitleTornado chart:horizontal stacked chartAxis titleSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.0.860.780.600.380.180.120.040.160.840.500.601.060.210.180.350.240.00.51.01.52.02.53.0Category ACategory BCategory CCategory DCategory ECa

22、tegory FCategory GCategory HTitle,time periodSubtitleGeneral rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot and bubble graphs Presenter/timingAgendaBasic line graph05010015020

23、02503003501996199719981999200020012002E2003EWorldwideUnited StatesCAGR1996-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 sizeTitle,time periodSubtitle Basic line graph with data labelsSource:Text i

24、s Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.386997132170320395267841071362281423100501001502002503003501996199719981999200020012002E2003EWorldwideUnited StatesCAGR1996-2003xx%xx%Title,time periodSubtitleMulti-line graph with CAGRSource:Text is Arial,8-

25、point,plain;a semicolon should separate each item;the line should end in a period.Axis titleAxis title05101520253019981999200020012002EClientCompetitor 1Competitor 2Competitor 3Competitor 4CAGR1998-2002xx%xx%xx%xx%xx%Title,time periodSubtitleLine graph:dual axisSource:Text is Arial,8-point,plain;a s

26、emicolon should separate each item;the line should end in a period.Axis titleAxis title01020304050EastWestNorthSouth01020304050Series ASeries BAxis titleTitle,time periodSubtitleSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Axis titleAxis ti

27、tle01020304050EastWestNorthSouth200220240260280300Series ASeries BAxis title0The break lines and the zero marker are added separatelyTitle,time periodSubtitleLine graph:dual axis (with pasted scale break on secondary axis)Combination line and column graph:dual-axisSource:Text is Arial,8-point,plain;

28、a semicolon should separate each item;the line should end in a period.Axis titleAxis title01020304050EastWestNorthSouth020406080100120140160Series ASeries BTitle,time periodSubtitleAxis titleHalf-size line graphsAxis titleAxis titleAxis titleAxis titleTitle,time periodaSubtitleTitle,time periodbSubt

29、itleAxis title050100150200250300350199719981999200020012002E 2003E 2004EWorldwideUnited StatesSource:(a)Source for first graph;(b)Source for second graph.01020304050EastWestNorthSouth020406080100120140160Series ASeries BOne-third-size line graphsAxis titleAxis titleAxis titleTitle,time periodcSubtit

30、leTitle,time periodbSubtitleTitle,time periodaSubtitle0501001502002503003501996199719981999200020012002E2003EWorldwideUnited States0204060801001201996199719981999200020012002E2003E01020304050EastWestNorthSouth020406080100120140160Series ASeries BAxis titleAxis titleAxis titleAxis titleSource:(a)Sour

31、ce 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 titleAxis titleBell curve chart(no data)Source:Text is Arial,8-point,p

32、lain;a semicolon should separate each item;the line should end in a period.Title of chartSubtitleAxis titleAxis titleAgendaGeneral rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter pl

33、ot and bubble graphs Presenter/timingArea graph:data labels insideSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleClientCompetitor 1Competitor 2Competitor 3020406080100120199719981999200020012002E20

34、03E2004E Area graph:legend includedSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis title020406080100120199719981999200020012002E2003E2004ECompetitor 3Competitor 2Competitor 1Client100%stacked area graphS

35、ource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodSubtitleAxis titleAxis titleClientCompetitor 1Competitor 2Competitor 30%20%40%60%80%100%199719981999200020012002E2003E2004EHalf-size area and 100%stacked area graphsAxis titleAxis

36、 titleAxis titleAxis title020406080100120ABCDEFGH0%20%40%60%80%100%ABCDEFGHTitle,time periodaSubtitleTitle,time periodbSubtitleClientCompetitor 1Competitor 2Competitor 3ClientCompetitor 1Competitor 2Competitor 3Source:(a)Source for first graph;(b)Source for second graph.One-third-size area graphsAxi

37、s titleTitle,time periodcSubtitleAxis titleTitle,time periodbSubtitleTitle,time periodaSubtitle020406080100120ABCDEFGH020406080100120ABCDEFGH0%20%40%60%80%100%ABCDEFGHSource:(a)Source for first graph;(b)Source for second graph;(c)Source for third graph.ClientCompetitor 1Competitor 2Competitor 3Clien

38、tCompetitor 1Competitor 2Competitor 3ClientCompetitor 1Competitor 2Competitor 3Axis titleAxis titleAxis titleAxis titleGeneral rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie graphs Presenter/timingScatter plot a

39、nd bubble graphs Presenter/timingAgendaSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Title,time periodTotal=xx millionCategory A40%Category B24%Category C16%Category D9%Category E7%Category F4%Order the pieces from largest to smallest,unless

40、 some other order is appropriate.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 outsidePie graph:labels on insideSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end

41、 in a period.Title,time periodTotal=xx millionCategory A43%Category B26%Category D14%Category C17%The data labels are positioned in the“center”and then moved as neededHalf-size pie graphsTitle,time periodaSubtitleSource:(a)Source for first graph;(b)Source for second graph.Title,time periodbSubtitleC

42、ategory A40%Category B24%Category C16%Category D9%Category E7%Category F4%Category A43%Category B26%Category D14%Category C17%These“leader lines”can be set automatically under“Chart Options/Data Labels”Data labels should be either all inside or all outside the pie pieces Half-size pie graphs with se

43、parated piece Title,time periodaSubtitleSource:(a)Source for first graph;(b)Source for second graph.Title,time periodbSubtitleCategory A40%Category B24%Category C16%Category D9%Category E7%Category F4%Category A43%Category B26%Category D14%Category C17%Create pie graph as usual,then move out selecte

44、d piece manuallyDual pie-of-pie graphTitle,time periodaSubtitleCategory A38%Category E9%Category D13%Category C17%Category B23%Source:(a)Source for first graph;(b)Source for second graph.Title,time periodbSubtitleCategory W43%Category X26%Category Z14%Category Y17%To create this graph,enter the data

45、 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 positionGeneral rules Presenter/timingBar and column graphs Presenter/timingLine and combination graphs Presenter/timingArea graphs Presenter/timingPie

46、 graphs Presenter/timingScatter plot and bubble graphs Presenter/timingAgendaScatter plot with trendlinesSource:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.-2002040608010012001020304050Series ASeries BSeries CLinear(Series B)Linear(Series A)Poly.

47、(Series C)Title,time periodSubtitleAxis titleAxis titleTrendlines can be created and modified under the“Chart”menuScatter plot with four quadrants Title,time periodSubtitle-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 pointsSou

48、rce:Text is Arial,8-point,plain;a semicolon should separate each item;the line should end in a period.Complex scatter chart05101520253035400123456789ClientCompetitor 1Competitor 2Competitor 3Title,time periodSubtitleAxis titleAxis titleSource:Text is Arial,8-point,plain;a semicolon should separate e

49、ach item;the line should end in a period.Bubble graph-5%0%5%10%15%20%25%0%5%10%15%20%25%Title,time periodaSubtitleAxis TitleAxis 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 graph0306019981999200020012002Title,time periodaSubtitleAxis titleAxis 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.