excel制作分学历男女比例图
发布时间：2017-12-13 16:49:49
1、选择要生成图表的数据-插入图表-选择图表类型
![](https://wkrtcs.bdimg.com/rtcs/image?w=614.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"614.00","h":"318.00","dataType":"png","c":"word/media/image1.png","imgOriW":856,"imgOriH":348})
2、删除多余网格线：点击选中-delete
3、点击选中要生成次坐标的数据-右键-左键单击“设置数据系列格式”
![](https://wkrtcs.bdimg.com/rtcs/image?w=570.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"570.00","h":"342.00","dataType":"png","c":"word/media/image2.png","imgOriW":570,"imgOriH":342})
4、选择次坐标轴
![](https://wkrtcs.bdimg.com/rtcs/image?w=478.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"478.00","h":"492.00","dataType":"png","c":"word/media/image3.png","imgOriW":478,"imgOriH":492})
![](https://wkrtcs.bdimg.com/rtcs/image?w=488.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"488.00","h":"293.00","dataType":"png","c":"word/media/image4.png","imgOriW":488,"imgOriH":293})
5、在“布局”中分别设置各个坐标轴
![](https://wkrtcs.bdimg.com/rtcs/image?w=297.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"297.00","h":"252.00","dataType":"png","c":"word/media/image5.png","imgOriW":297,"imgOriH":252})
6、主要横坐标轴设置—“其他主要横坐标轴设置”
![](https://wkrtcs.bdimg.com/rtcs/image?w=473.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"473.00","h":"375.00","dataType":"png","c":"word/media/image6.png","imgOriW":473,"imgOriH":375})
根据数据大小选择合适的值设置
![](https://wkrtcs.bdimg.com/rtcs/image?w=296.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"296.00","h":"269.00","dataType":"png","c":"word/media/image7.png","imgOriW":296,"imgOriH":269})
7、次要横坐标轴设置—“其他主要横坐标轴设置”
![](https://wkrtcs.bdimg.com/rtcs/image?w=469.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"469.00","h":"367.00","dataType":"png","c":"word/media/image8.png","imgOriW":469,"imgOriH":367})
8、主要纵坐标轴设置—“其他主要横坐标轴设置”
![](https://wkrtcs.bdimg.com/rtcs/image?w=479.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"479.00","h":"444.00","dataType":"png","c":"word/media/image9.png","imgOriW":479,"imgOriH":444})
![](https://wkrtcs.bdimg.com/rtcs/image?w=389.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"389.00","h":"224.00","dataType":"png","c":"word/media/image10.png","imgOriW":389,"imgOriH":224})
根据个人喜好设置线条或者背景颜色
9、次要纵坐标轴设置—“其他主要横坐标轴设置”
![](https://wkrtcs.bdimg.com/rtcs/image?w=429.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"429.00","h":"448.00","dataType":"png","c":"word/media/image11.png","imgOriW":429,"imgOriH":448})
![](https://wkrtcs.bdimg.com/rtcs/image?w=483.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"483.00","h":"289.00","dataType":"png","c":"word/media/image12.png","imgOriW":483,"imgOriH":289})
10、然后添加标题、图例、数据标签
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"553.00","h":"160.00","dataType":"png","c":"word/media/image13.png","imgOriW":553,"imgOriH":160})
![](https://wkrtcs.bdimg.com/rtcs/image?w=482.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"482.00","h":"286.00","dataType":"png","c":"word/media/image14.png","imgOriW":482,"imgOriH":286})
11、根据个人喜好进行设置字体、图表颜色等
![](https://wkrtcs.bdimg.com/rtcs/image?w=439.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"439.00","h":"129.00","dataType":"png","c":"word/media/image15.png","imgOriW":439,"imgOriH":129})
![](https://wkrtcs.bdimg.com/rtcs/image?w=481.00&md5sum=747764786cd90c413a1c6d4c04ba3a92&sign=b64d50e3f9&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=92&ipr={"t":"img","r":"r_3","w":"481.00","h":"281.00","dataType":"png","c":"word/media/image16.png","imgOriW":481,"imgOriH":281})
相关推荐
舌尖上的中国完整解说词复习过程
讲规矩、有纪律四讲四有考题
学生会劳卫部工作计划范文3篇
高二班主任第一次班会发言稿
2019年整理公司劳动人事管理及劳动合同签定应注意的几个问题
廉政知识测试题及答案
落实全面从严治党主体责任规定学习讲话
幼儿园大班简短童话故事大全
pr入门教程
0拼音读法大全
