如何在excel2003中绘制双轴柱状图和折线图
如何绘制双轴柱状图和折线图,
答:第1步,先将数据作成如下
格。
××市2010--2014年农业灌溉用水有效利用系数
灌溉亩数毛灌溉用水总量净灌溉用水总量灌溉水有效考核年份 33(万亩) (万米) (万米) 利用系数
2010年 1.57 1440 691 0.48 0.55
2011年 1.57 1142 628 0.55 0.55
2012年 1.57 966 628 0.65 0.55
2013年 1.57 966 628 0.65 0.55
2014年 1.57 966 628 0.65 0.55
第2步,将所需数据列选中,如下图。
××市2010--2014年农业灌溉用水有效利用系数
灌溉亩数 净灌溉用水总量 灌溉水有效 考核 毛灌溉用水总量年份 33(万米) (万亩) (万米) 利用系数 标准
2010年 1.57 1440 691 0.48 0.55
2011年 1.57 1142 628 0.55 0.55
2012年 1.57 966 628 0.65 0.55
2013年 1.57 966 628 0.65 0.55
2014年 1.57 966 628 0.65 0.55
第3步,点插入,点图表,出来图表向导后,点自定义类型,选择两轴线--柱图,点下一步,点系列,分别选中系列(s)下的系列2、系列1、系列3、系列4,同时分别在对应的名称下进行重命名。最后在分类(x)轴标志的右侧点,选择电子表格中的年份列,如下图。
that construction site clean, consciously maintain sanitation. (4) ensure the safety of materials and semi-finished products. 8. quality assessment, data compilation: buried, belongs to the concealed works construction, therefore its quality inspection must be carried out according to acceptance of concealed work-related. Mainly in the following aspects: (1) acceptance of positioning is accurate. (2) is fixed securely. (3) tightening compliance requirements. (4) have an impact on other projects. (5) the material used is eligible. (6) complete information has been collected. Documentation: should follow construction progress at any time finishing self acceptance, signature acceptance after the representatives of the party were invited. Requirements: (1) covert acceptance is the
再点,出现下图。
然后点下一步,出现下图。
nce is theg self acceptance, signature acceptance after the representatives of the party were invited. Requirements: (1) covert acceptanishind is eligible. (6) complete information has been collected. Documentation: should follow construction progress at any time fite. (2) is fixed securely. (3) tightening compliance requirements. (4) have an impact on other projects. (5) the material userelated. Mainly in the following aspects: (1) acceptance of positioning is accura-ied out according to acceptance of concealed workessment, data compilation: buried, belongs to the concealed works construction, therefore its quality inspection must be carrfinished products. 8. quality ass-that construction site clean, consciously maintain sanitation. (4) ensure the safety of materials and semi- 2 -
在图表标题栏输入图表名称,在分类(X)轴栏输入名称,在数值(Y)轴栏输入名称,在次数值(Y)轴栏输入名称,点下一步,出现下图。
点下一步,出现下图。
再点完成,就出现下图。
××市2010--2014年农业灌溉用水有效利用系数
0.71600
14000.6
12000.5毛灌溉用水总量10000.4净灌溉用水总量800灌溉水有效利用系数0.3600考核标准0.2400
0.1200毛灌溉用水总量万米净灌溉用水总量万米(3)(3)
00
2010年2011年2012年2013年2014年
年份
equirements: (1) covert acceptance is then progress at any time finishing self acceptance, signature acceptance after the representatives of the party were invited. Ructioprojects. (5) the material used is eligible. (6) complete information has been collected. Documentation: should follow constr ptance of positioning is accurate. (2) is fixed securely. (3) tightening compliance requirements. (4) have an impact on otherrelated. Mainly in the following aspects: (1) acce-quality inspection must be carried out according to acceptance of concealed worknished products. 8. quality assessment, data compilation: buried, belongs to the concealed works construction, therefore its fi-that construction site clean, consciously maintain sanitation. (4) ensure the safety of materials and semi- 3 -
将鼠标放在上,击右键,点图例格式,点位
置,出现下图。
点靠上,点确定,出现下图。
××市2010--2014年农业灌溉用水有效利用系数
毛灌溉用水总量净灌溉用水总量灌溉水有效利用系数考核标准
16000.7
14000.6
12000.5
10000.4
800
0.3600
0.2400毛灌溉用水总量(m3)净灌溉用水总量同(m3)0.1200
00
2010年2011年2012年2013年2014年
年份
第4步,如果想改变字体的字形和字号大小及上、下标,
双击文字或数字(也可击右键进行选择)即可,出现下图。
nce is theg self acceptance, signature acceptance after the representatives of the party were invited. Requirements: (1) covert acceptanishind is eligible. (6) complete information has been collected. Documentation: should follow construction progress at any time fite. (2) is fixed securely. (3) tightening compliance requirements. (4) have an impact on other projects. (5) the material userelated. Mainly in the following aspects: (1) acceptance of positioning is accura-ied out according to acceptance of concealed workessment, data compilation: buried, belongs to the concealed works construction, therefore its quality inspection must be carrfinished products. 8. quality ass-that construction site clean, consciously maintain sanitation. (4) ensure the safety of materials and semi- 4 -
××市2010--2014年农业灌溉用水有效利用系数
毛灌溉用水总量净灌溉用水总量灌溉水有效利用系数考核标准16000.714000.6
)31200)30.510000.4800
0.3600
0.2毛灌溉用水总量(m净灌溉用水总量同400(m
0.1200
00
2010年2011年2012年2013年2014年
年 份
第5步,如果想去掉图中的底色,将光标放置于图中的底
色上,击右键点清除,即可出现下图。
××市2010--2014年农业灌溉用水有效利用系数
毛灌溉用水总量净灌溉用水总量灌溉水有效利用系数考核标准16000.714000.6
)3)120030.510000.4800
0.3600
0.2毛灌溉用水总量(m净灌溉用水总量同400(m
0.1200
00
2010年2011年2012年2013年2014年
年 份
equirements: (1) covert acceptance is then progress at any time finishing self acceptance, signature acceptance after the representatives of the party were invited. Ructioprojects. (5) the material used is eligible. (6) complete information has been collected. Documentation: should follow constr ptance of positioning is accurate. (2) is fixed securely. (3) tightening compliance requirements. (4) have an impact on otherrelated. Mainly in the following aspects: (1) acce-quality inspection must be carried out according to acceptance of concealed worknished products. 8. quality assessment, data compilation: buried, belongs to the concealed works construction, therefore its fi-that construction site clean, consciously maintain sanitation. (4) ensure the safety of materials and semi- 5 -