基期图表_lbzcc.xlsx

Fortune best 100 companies to work forCRSP value-weighted indexFortune best 100 companies to work forCRSP value-weighted index19981001001999222819991251252000401820001601500112-20120014002-12.5-13.50216012503-19-210314595045939.5042101300510.580523014506181506275160079140730517508-11.5-1.5082501800910-1309240150时间轴隐藏不必要的刻度线199810 19990.5000.0220 20001.5010.022000302.5020.0240 023.5030.0202504.5040.0260 045.5050.0204706.5060.0280 067.5070.0206908.5080.02100 089.5090.0208110 0910.50100.0209120110.02起点&标记线正负号1100110.35+110.3110.25-图表一步骤图表二步骤以区域A2:C13做XY折线图图，并删除图例以区域F1:G12做簇状柱型图1999200002040608093020100102030405060Fortune best 100 companies to work forCRSP value-weighted index14121086420050100150200250300350Fortune best 100companies towork forCRSPvalue-weightedindex1998200002040608090000501001502002503003501234567891011-30-20-10010203040506070Fortune best 100 companies to work forCRSP value-weighted index添加系列起点&标记线，值为B29单元格中的值，并设置数据标记为圆形红色，数据标记线白色以区域C29:D30添加系列为散点XY图修改数值X轴交Y轴与最大值，并修改数值X轴最大值为12.5最小值为1将柱型图绘制在次轴 散点图绘制在主轴，并分别设置两轴的最大值和最小值如图；分别设置X轴最大值和最小值为11和0为系列“起点&标记线”添加水平误差线 误差量为12设置系列正负号为无数据标记，并添加数据标志显示在右方并用下贴的工具修改标签值为E29:E30http:/ best 100 companies to work forCRSP value-weighted index正负号108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index141210864200501001502002503003501234567891011-30-20-10010203040506070Fortune best 100 companies to work forCRSP value-weighted index分别设置X轴无标签 Y轴无线条，无刻度线以区域E15:F25添加系列刻度值，图表类型为XY散点图；以数据源区域B15:C26 添加系列“时间轴”,并添加数据标签在下方，并设置系列为无数据标志 无线条颜色设置系列刻度值显示在主轴，设置X轴为无标签，并将主次刻度值设置为1；添加系列刻度线的数据标志 并用前面的工具修改标志为区域D15:D25050100150200250300350000000000000050100150200250300350+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index1197531050100150200250300350+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index用下帖的工具修改数据标签为A15:A26http:/ 并显示在主轴分别选中图中被标记的两个数据点（此数据点是为了方便大家看到故意标示出来的）。显示数据标签设置系列隐藏不必要的刻度线数据标记为正方形颜色为图表区底色，并适当调整大小 以遮挡不需要的刻度线调整标签颜色Y轴坐标轴格式数值为自定义：红色=100G/通用格式;000以区域A30:B30添加系列标记红线，图表类型为XY散点图199820000204060809050100150200250300350Fortune best 100companies towork forCRSPvalue-weightedindex199820000204060809000050100150200250300350Fortune best 100companies towork forCRSPvalue-weightedindex199820000204060809050100150200250300350+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index000000000000050100150200250300350+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index最后调整一下图表网格线颜色和坐标轴数值的颜色就OK了为系列标记红线添加X轴误差线设置次数值轴数字为自定义：G/通用格式;G/通用格式;红色G/通用格式;Fortune best 100companies towork forCRSPvalue-weightedindex199820000204060809000050100150200250300350+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.93020100102030405060Fortune best 100 companies to work forCRSP value-weighted indexFortune best 100companies towork forCRSPvalue-weightedindex199820000204060809000050100150200250300350+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index最后调整图片格式如图199920000204060809+-3020100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.93020100102030405060Fortune best 100 companies to work forCRSP value-weighted index图表二步骤以区域F1:G12做簇状柱型图199920000204060809+-3020100102030405060Fortune best 100 companies to work forCRSP value-weighted index1234567891011-30-20-10010203040506070Fortune best 100 companies to work forCRSP value-weighted index1234567891011-30-20-10010203040506070Fortune best 100 companies to work forCRSP value-weighted index添加系列起点&标记线，值为B29单元格中的值，并设置数据标记为圆形红色，数据标记线白色以区域C29:D30添加系列为散点XY图将柱型图绘制在次轴 散点图绘制在主轴，并分别设置两轴的最大值和最小值如图；分别设置X轴最大值和最小值为11和0设置系列正负号为无数据标记，并添加数据标志显示在右方并用下贴的工具修改标签值为E29:E30http:/ best 100 companies to work forCRSP value-weighted index正负号108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index以区域E15:F25添加系列刻度值，图表类型为XY散点图；以数据源区域B15:C26 添加系列“时间轴”,并添加数据标签在下方，并设置系列为无数据标志 无线条颜色设置系列刻度值显示在主轴，设置X轴为无标签，并将主次刻度值设置为1；添加系列刻度线的数据标志 并用前面的工具修改标志为区域D15:D25+-108642000.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index以区域G15:H26添加系列隐藏不必要的刻度线，图表类型为XY散点图 并显示在主轴分别选中图中被标记的两个数据点（此数据点是为了方便大家看到故意标示出来的）。显示数据标签设置系列隐藏不必要的刻度线数据标记为正方形颜色为图表区底色，并适当调整大小 以遮挡不需要的刻度线以区域A30:B30添加系列标记红线，图表类型为XY散点图+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index为系列标记红线添加X轴误差线设置次数值轴数字为自定义：G/通用格式;G/通用格式;红色G/通用格式;+-19992000020406080900.10.20.30.40.50.60.70.80.9-30-20-100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.10.20.30.40.50.60.70.80.93020100102030405060Fortune best 100 companies to work forCRSP value-weighted index+-19992000020406080900.1020.30.40.50.60.70.80.93020100102030405060Fortune best 100 companies to work forCRSP value-weighted index最后调整图片格式如图199920000204060809+-3020100102030405060Fortune best 100 companies to work forCRSP value-weighted index将柱型图绘制在次轴 散点图绘制在主轴，并分别设置两轴的最大值和最小值如图；分别设置X轴最大值和最小值为11和0设置系列刻度值显示在主轴，设置X轴为无标签，并将主次刻度值设置为1；添加系列刻度线的数据标志 设置系列隐藏不必要的刻度线数据标记为正方形颜色为图表区底色，并适当调整大小 以遮挡不需要的刻度线