Wps2016表格——插入图表并改变横坐标的方法
1.输入所需数据
![](https://wkrtcs.bdimg.com/rtcs/image?w=540&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"540","h":"55","dataType":"png","c":"word/media/image1.png","imgOriW":540,"imgOriH":55})
2.选中数据然后点“插入”→“图表”→“柱形图”
![](https://wkrtcs.bdimg.com/rtcs/image?w=551&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"551","h":"302","dataType":"png","c":"word/media/image2.png","imgOriW":656,"imgOriH":360})
3.右击中间图表点击“选择数据”
![](https://wkrtcs.bdimg.com/rtcs/image?w=370&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"370","h":"220","dataType":"png","c":"word/media/image3.png","imgOriW":370,"imgOriH":220})
4.改变图表数据区域，如第一排数据
![](https://wkrtcs.bdimg.com/rtcs/image?w=453&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"453","h":"189","dataType":"png","c":"word/media/image4.png","imgOriW":940,"imgOriH":373})
5.点击“系列”里的![](https://wkrtcs.bdimg.com/rtcs/image?w=46&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"46","h":"42","dataType":"png","c":"word/media/image5.png","imgOriW":46,"imgOriH":42})
图标
![](https://wkrtcs.bdimg.com/rtcs/image?w=465&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"465","h":"269","dataType":"png","c":"word/media/image6.png","imgOriW":465,"imgOriH":269})
.
6.按需要修改“系列名称”的内容
![](https://wkrtcs.bdimg.com/rtcs/image?w=319&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"319","h":"183","dataType":"png","c":"word/media/image7.png","imgOriW":319,"imgOriH":183})
7.点击“类别”后的图标，选择需要做横坐标的数据区域，“确定”，再“确定”，完成
![](https://wkrtcs.bdimg.com/rtcs/image?w=540&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"540","h":"270","dataType":"png","c":"word/media/image8.png","imgOriW":540,"imgOriH":270})
![](https://wkrtcs.bdimg.com/rtcs/image?w=32&md5sum=566c11e9a31817bd2c7cd600d32fd3a1&sign=af4b843696&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=70&ipr={"t":"img","w":"32","h":"73.333333333333","dataType":"gif","c":"word/media/image9.png"})
本文来源：https://www.2haoxitong.net/k/doc/3559707b69dc5022abea006b.html
文档为doc格式