Office 010Excel中如何用双X轴或双Y轴坐标作图.docVIP

Office 2010　Excel中如何用双X轴或双Y轴坐标作图 2011-03-26 00:48:36| 分类： Office|字号 订阅 Office 2010　Excel中如何用双X轴或双Y轴坐标作图？ 作图之前，一些规定我们必须知道，先做如下解释：所谓双X轴坐标，即有２个X轴，主X轴和次X轴，Excel中规定图表下方刻度为主X轴，上方刻度为次X轴；所谓双Y轴坐标，即有２个Y轴，主Y轴和次Y轴，Excel中规定图表左方刻度为主Y轴，右方刻度为次Y轴；我们作图一般用主X轴和主Y轴就可满足要求，但很多时候我们可能会用到主X、主Y、次X、次Y，因此，我们应该知道更多的作图技巧： １、用主X轴和主Y轴作图，这是最普通，也是最简单的一种，不再赘述。２、双Y轴坐标：即１个X轴，２个Y轴，因此，数据上应为３列数据，先用１个X轴和１个Y轴数据作图，此时出现主X轴和主Y轴，然后再将第２个Y轴数据添加到图中，此时图中出现２个曲线，将其中一条曲线坐标设为次Y轴，即完成双Y轴坐标图，步骤如下： ３、双X轴坐标：如果理解为１个Y轴，２个X轴，那可就错了，Excel中实现不了这种作图法。如果要想画双X轴坐标，必须先要画双Y坐标，这是规定，没有为什么。其实，如果你真想要１个Y轴，２个X轴的话，将主Y和次Y的坐标设为一样不就满足要求了吗。具体画法其实也不复杂，只需在双Y轴坐标的基础上，调整一些选项即可，在双Y的基础上，只需如下一步即可，注意在“图表工具”菜单中： 此图中柱状图坐标为次X和次Y（看时间） 蓝色线坐标为主X和主Y 具体作图细节不一一详述，相信大家都知道，最关键的更改坐标在如下对话框中进行，左边为纵坐标，右边为横坐标，一般为选中左边，更改右边： Tomb, by then Shanghai Communist Party sent, led by party member Ding Bingcheng, working in Taihu area, Jiangsu and Zhejiang provinces to the East. Wu Jiang Shi Guang, with him more than 20 people, among Communist Party members, but mostly the resistance members (according to the provisions of the organizational Department of the CPC Central Committee on intelligence cadre party, participating in anti- date of intelligence work, is the Tomb, by then Shanghai Communist Party sent, led by party member Ding Bingcheng, working in Taihu area, Jiangsu and Zhejiang provinces to the East. Wu Jiang Shi Guang, with him more than 20 people, among Communist Party members, but mostly the resistance members (according to the provisions of the organizational Department of the CPC Central Committee on intelligence cadre party, participating in anti- date of intelligence work, is the Tomb, by then Shanghai Communist Party sent, led by party member Ding Bingcheng, working in Taihu area, Jiangsu and Zhejiang provinces to the East. Wu Jiang Shi Guang, with him more than 20 people, among Communist Party members, but mostly the resistance members (according to the provisions of the organizational Department of the CPC Central Committee on inte