-EXCEL-visio图形图表制作PPT课件

1,EnglishPaperWriting&publication,Howtodotables/figures/graphs,2,HowtomakegraphsinEXCEL,UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,UsingshapesandgraphstomakeabeautifulPPT,3,Organizationalgraph(组织结构图),Map（地图）,Flowdiagram（流程图）,Conceptualgraph（概念图）,Introduceofgraphs,1.Non-datacategoryofgraphs,4,Table(表格),ColumnDiagram（柱形图）,BarDiagram（条形图）,PieDiagram饼图,LineGraph折线图,ScatterDiagram散点图,2.Datacategoryofgraphs,Introduceofgraphs,5,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,6,柱形图反映一段时间内数据的变化，或者不同项目之间的对比，是最常见的图表之一，是Excel的默认图表。子图表类型：二维柱形图三维柱形图圆柱图圆锥图棱锥图,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,1、ColumnDiagram（柱形图）,7,1、HowtomakegraphsinEXCEL,Exampleofcolumndiagram（柱形图）,8,折线图按照相同的间隔显示数据的趋势。子图表类型：折线图堆积折线图百分比堆积折线图数据点折线图堆积数据点折线图百分比堆积数据点折线图三维折线图,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,2、LineGraph（折线图）,9,1、HowtomakegraphsinEXCEL,Exampleoflinegraph（折线图）,10,饼图显示组成数据系列的项目在项目总和中所占的比例，通常只显示一个数据系列。子图表类型：饼图三维饼图复合饼图分离型饼图分离型三维饼图复合条饼图,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,3、PieDiagram（饼图）,11,1、HowtomakegraphsinEXCEL,ExampleofPieDiagram（饼图）,12,条形图也是显示各个项目之间的对比，与柱形图不同的是其分类轴设置在纵轴上，而柱形图则设置在横轴上。子图表类型：二维柱形图三维柱形图圆柱图圆锥图棱锥图,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,4、BarDiagram（条形图）,13,1、HowtomakegraphsinEXCEL,ExampleofBarDiagram（条形图）,14,TypesofgraphinEXCEL,9kindsofgraphsinExcel,1、HowtomakegraphsinEXCEL,5、AreaGraph（面积图）,6、ScatterDiagram（散点图）,7、RadarMap（雷达图）,8、StockChart（股价图）,9、SurfaceChart（曲面图）,15,Choosedataarea,Insertgraph,detaildesigns,Finishagraph,1、HowtomakegraphsinEXCEL,ProcessofmakinggraphinEXCEL,16,1、HowtomakegraphsinEXCEL,ProcessofmakinggraphinEXCEL,17,2013版：格式合并形状；2010版：文件选项自定义功能区不在功能区的命令（需要添加）,2、UsingshapestomakeabeautifulPPT,learntousetheshapesinthePowerPoint,18,与男人沟通，不要忘了他的面子；与女人沟通，不要忘了他的情绪；与领导沟通，不要忘了他的尊严；与下属沟通，不要忘了他的自尊；与年轻人沟通，不要忘了他的直接；与儿童沟通，不要忘了他的天真。,边框阴影,形状剪除,2、UsingshapestomakeabeautifulPPT,learntousetheshapesinthePowerPoint,19,2、UsingshapestomakeabeautifulPPT,learntousetheshapesinthePowerPoint,20,2、UsingshapestomakeabeautifulPPT,learntousetheshapesinthePowerPoint,21,2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,22,一、List(列表),2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,23,二、Circle（循环）,2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,24,三、Levels(层次结构),2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,25,四、Relation（关系）,2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,26,五、Flow（流程）,2、UsingshapestomakeabeautifulPPT,learntousetheSMARTARTofthePowerPoint,27,2、UsingshapestomakeabeautifulPPT,somebeautifulsamples,28,2、UsingshapestomakeabeautifulPPT,somebeautifulsamples,29,2、UsingshapestomakeabeautifulPPT,somebeautifulsamples,30,2、UsingshapestomakeabeautifulPPT,somebeautifulsamples,31,2、UsingshapestomakeabeautifulPPT,somebeautifulsamples,32,3、UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,Microsoftvisio&flowdiagram,3、UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,Microsoftvisio&flowdiagram,34,1、Sequence（循序结构）（一）图形：（二）意义：处理程序循序进行。（三）语法：DO处理程序1THENDO处理程序2,3、UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,Microsoftvisio&flowdiagram,Somebasicflowstructure,35,或,2、Selection（选择结构）二元选择结构（基本结构）（一）图形：（二）意义：流程依据某些条件，分别进行不同处理程序。（三）语法：IF条件THENDO处理程序1ELSEDO处理程序2,3、UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,Microsoftvisio&flowdiagram,Somebasicflowstructure,36,3、Selection（选择结构）多重选择结构（二元选择结构变化结构）（一）图形：（二）意义：流程依据某些条件，分别进行不同处理程序。（三）语法：FOR条件PCASE1DO处理程序1CASE2DO处理程序2.CASEnDO处理程序n,3、UsingVISIOtomakeitmoreconvenientofdrawingflowdiagram,Microsoftvisio&flowdiagram,Somebasicflowstructure,37,4、Iteration（重复结构）REPEAT-UNTIL结构