管理利剑之EXCEL经典图表.xlsVIP

20-WBS 19-直方和正态图2 19-直方和正态图1 18-波士顿矩阵 17-流程图 16-比较柱状 15-自动更新 14-单点图 13-甘特图 12-圆柱、圆锥、棱锥图 11-股价图3 11-股价图2 11-股价图1 10-气泡图 9-曲面图 8-雷达图2 8-雷达图1 7-圆环图 6-面积图 5-XY散点图2 5-XY散点图1 4-饼图2 4-饼图1 3-拆线图3 3-拆线图2 3-拆线图1 2-条形图 1-柱形图 目录 average .00 .00 1.00 cap .00 DATA Date .00 .00 1.00 1.00 highest .00 .00 1.00 lowest .00 .00 1.00 month .00 .00 1.00 ry .00 Sales .00 .00 1.00 1.00 x_data .00 1.00 Y -1.00 y1_data 1.00 y2_data 1.00 y3_data 1.00 区域1 .00 .00 1.00 1.00 区域2 .00 .00 1.00 数据 条件 月份 .00 .00 1.00 序号 Task Start Date Duration Planning Meeting Develop Questionnaire Print and Mail Questionnaire Receive Responses Data Entry Data Analysis Write Report Distribute Draft Report Solicit Comments Finalize Report Distribute to Board Board Meeting 4)删除图例，单击完成 5)调整图表及字体的大小 Year Widgets Sprockets 1997 1998 1999 2000 2001 Item Strongly Agree Agree Undecided Disagree Strongly Disagree Store locations are convenient Store hours are convenient Stores are well-maintained I like your web site Employees are friendly You have a good selection of products I like your TV ads You sell quality products Overall, I am satisfied I would recommend your company National RD expenditures, by source of funds: 1953–2000 Industry Federal Other Population Projections (in thousands) California Oregon Washington 1995 2005 2015 2025 Excel 2002 Excel 2000 Excel 97 Excel 95 Other version Category Amount Rent Supplies Miscellaneous Region 1 Salary Region 2 Salary Region 3 Salary Region 4 Salary Month Calls Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec X Y Product A Product B Product C Qtr-1 Qtr-2 Qtr-3 Qtr-4 Sales by State 1st Half 2nd Half Total Red Green Blue Color-1 Color-2 Color-3 Color-4 Note: The color palette for this workbook was modified to include the three colors shown in the charts. These colors are not normally part of the default color palette. Snow Ski Sales Water Ski Sales Participant Original Wieight Weeks in Program Weight Loss Ray Pat Jill George Kevin Joe Cindy Terry Date Volume Open High Low C