Excel图表实用教程Chart

用细分条形图做不等框条形图原始数据：％ of votersObama mMcCain18-2410%66%2%32%18-24 ( 10% ) 10%25-298%66%3%31%25-29 ( 8% ) 18%30-3918%54%2%44%30-39 ( 18% ) 36%40-4921%49%2%49%40-49 ( 21% ) 57%50-6426%50%1%49%50-64 ( 26% ) 83%65+ 17%45%2%53%65+ ( 17% ) 100%step:1、用作图数据区域M6:O15做条形堆积图;5%-0.12、扩展数据源至整个数据区14%-0.13、反转分类次序27%-0.14、设置所有序列无框，按例图填色(组距设定为O),刻度设定为无47%-0.1图标放大设定中间系列为无70%-0.15、加入数据标签、坐标轴标签92%-0.10%20%40%60%80%100%1112131415161718191101返回18－2425－2930－390%10%18%10%18%36%66%2%32%66%3%31%54%2%44%作图数据区：1%66%2%32%2%66%2%32%3%66%2%32%4%66%2%32%5%66%2%32%33%84%6%66%2%32%33%85%7%66%2%32%27%78%8%66%2%32%25%76%9%66%2%32%25%76%10%66%2%32%23%74%11%66%3%31%12%66%3%31%13%66%3%31%14%66%3%31%15%66%3%31%16%66%3%31%17%66%3%31%18%66%3%31%19%54%2%44%20%54%2%44%21%54%2%44%22%54%2%44%23%54%2%44%24%54%2%44%25%54%2%44%26%54%2%44%27%54%2%44%28%54%2%44%29%54%2%44%30%54%2%44%31%54%2%44%32%54%2%44%33%54%2%44%34%54%2%44%35%54%2%44%36%54%2%44%37%38%39%40%41%42%43%44%45%46%47%48%49%50%51%52%53%54%55%56%57%58%59%60%61%62%63%64%65%66%67%68%69%70%71%72%73%74%75%76%77%78%79%80%81%82%83%84%85%86%87%88%89%90%91%92%93%94%95%96%97%98%99%100%40－4950－6465＋ 36%57%83%57%83%100%49%2% 49%50%1% 49%45%2% 53%49%2% 49%49%2% 49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%49%2%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%50%1%49%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%45%2%53%