excel2007制作相关分析图表具体步骤

《excel2007制作相关分析图表具体步骤》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、EXCEL2007制作相关分析图表具体步骤一、数据（黄河三角洲数据）年份年平均气温（°C）年平均降水（mm）198011.94474.32198112.38417.47198213.02439.53198312.60630.80198412.60630.80198512.64429.24198613.06617.96198712.55640.85198813.08517.60198913.32404.78199013.32933.55199112.83607.72199212.70375.64199312.825

2、85.80199413.71694.24199513.37692.48199613.08664.68199713.48480.95199814.07693.07199914.17512.13200013.80449.45200113.82519.70200214.10361.32200313.37746.87200414.08762.97200513.57647.05200614.05398.13200714.13680.88200813.56612.03200913.35662.85201013.01598.1

3、8201113.08665.37201213.10617.82201313.37710.58201414.25430.052015二、最终效果图（如下图）唄r卅年份Year三.具体操作步骤:1）选中三列数据，点击插入选项，选择散点图，如下图®afits筐OHa®CP看圄片勢貼至形状SmartAr1~TiD0406«三角气候茨矽统计舫J（h・

4、團表1ABC1■年份；年平均气温（匕）年平均降水（叭2198011.94474.323198112.38417.474198213.02439.535198312.60630

5、.806198412.60630.807198512.64429.248198613.06617.969198712.55640.850198813.08517.601198913.32404.782199013.32933.553199112.83607.724199212.70375.645199312.82585.806199413.71694.247199513.37692.488199613.08664.689199713.48480.950199814.07693.071199914.17512.13

6、2200013.80449.453200113.82519.704200214.10361.325200313.37746.876200414.08762.977200513.57647.058200614.05398.139200714.13680.880200813.56612.031200913.35662.85杀201013.01598.18)3201113.08665.37201213.10617.82街201313.37710.58J6201414.25430.052015渝館有旻克超©）・・・M炖＜

7、n细住形匿折线匿讲圄条形吏3^5IJK■叵罔4文乞电戻1艺术字筌舍行900.00800.00700.30600.00500.00400.00300.30200.00100301003.003.00―年平均气温「C）年平均降水（mm2）选择图表工具下的格式（1）,然后在2中选择需要添加为次坐标轴的数据名称，如下图因表]▼Aj=SERIES(Sheet4!$B$l?Sheet4«$A$2:$A$37,Shcet4l$B^2:$B$37,1)3]0406«三角PSSMJtfti+tt.xl"

8、~AB?CDEF:G〔HI

9、J'K1234，年份；年平均气温（匕）；年平均降水〈g198011.94474.32198112•歼417.47198213.02439.5356198312.60630.80198412.60630.807"819198512.64429.24198613.06617.96198712.55640.8510111213198813.08517.60198913.32404.78199013.32933.55199112.83607.721415199212.70375.64199312.82585.801617

10、18199413.71694.24199513.37692.48199613.08664.6819202122199713.48480.95199814.07693.07199914.17512.13200013.80449.452324200113.82519.70200214.10361・32252677200313.37746.87200414.08762.97少n