怎样在excel图表中的Y轴上确定一个数然后再对应的X轴上找出另一个数值...答:方法一:线性关系:Y=a*X+b(其中a和b为常数)可得:X=(Y-b)/a a =INDEX(LINEST(B1:B5,(A1:A5)^{1},1,1),1,1)b =INDEX(LINEST(B1:B5,(A1:A5)^{1},1,1),1,2)得:X =(C1-INDEX(LINEST(B1:B5,(A1:A5)^{1},1,1),1,2))/INDEX(LINEST(B1:B5,(A1:A5)^{1},1,...