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 periodSubtitle61072415051015
2、202530Category 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 1Dataset 2
3、Source: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 ICatego
4、ry 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 DCategory EDat
5、aset 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 graph610102415610102
6、41535712857914101341060%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 and off
7、 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 periodSubtitleAxis t
8、itleAxis 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 Column gra
9、ph,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,plain;a se
10、micolon 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 12135408454CAGRCate
11、gories 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 line sh
12、ould 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 step202020202020201400
13、20406080100120140ABCDEFGHSource: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 semicolon shou
14、ld 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 second
15、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 2Dataset 16
16、101061010357579341051015202530354045Category 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;(b)Sourc
17、e 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.163272518010203040
18、ABCDEAxis title471625320510152025303519981999200020012002E15712252105101520253019981999200020012002EAxis titleAxis titleAxis titleTitle,time periodaSubtitleTitle,time periodcSubtitleTitle,time periodbSubtitleOne-third-size waterfall and stacked column graphsAxis titleAxis titleSource:(a)Source for f
19、irst 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 titleAxi
20、s 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 periodSubtit
21、leTornado 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 ECategory F
22、Category 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 graph0501001502002503003
23、501996199719981999200020012002E2003EWorldwideUnited 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 is Arial,
24、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-point,pl
25、ain;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 semicolon
26、 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 title01020
27、304050EastWestNorthSouth200220240260280300Series 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;a semico
28、lon 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 periodbSubtitleAxis
29、 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 periodcSubtitleTitle,
30、time periodbSubtitleTitle,time periodaSubtitle0501001502002503003501996199719981999200020012002E2003EWorldwideUnited States0204060801001201996199719981999200020012002E2003E01020304050EastWestNorthSouth020406080100120140160Series ASeries BAxis titleAxis titleAxis titleAxis titleSource:(a)Source for f
31、irst 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,plain;a s
32、emicolon 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 plot and b
33、ubble 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 3020406080100120199719981999200020012002E2003E2004E
34、 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 graphSource:Te
35、xt 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 titleAx
36、is 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 graphsAxis titleT
37、itle,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 3ClientCompeti
38、tor 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 and bubbl
39、e 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 some ot
40、her 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 in a pe
41、riod.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 periodbSubtitleCategory
42、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 separated
43、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 selected piece
44、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 categor
45、ies 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 graphs
46、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.(Series
47、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 pointsSource:Text
48、 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 each item
49、;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.57 结束语结束语
