在Excel图表中缩放轴 [英] Scale axis in Excel chart

问题描述

我已在不同秒数记录了一些样本：

I have made a record of some samples at different seconds:

50  40  36  33  32  30  28  25  22  20  17  15  13  10  7   5

在Excel中创建带有标记的折线图时，x轴基于这些值，但是当然它们不是归一化的，因为存在从50到40比从22到20相同的距离。

When I create a line chart with markers in Excel, the x-axis is based on these values, but of course they are not normalised in the sense that there is the same distance from 50 to 40 than from 22 to 20.

是有一种方法，我可以绘制线与标记只在我已经记录的位置，并正确缩放在x轴？（所以从50到40没有数据在中间，但线不会下降到0，它应该只是链接到40的值顺利。格式轴似乎没有做任何事情）

Is there a way I can draw the line with the markers only at the positions I have recorded and that is properly scaled in the x-axis? (so from 50 to 40 there is no data in the middle but the line does not go down to "0", it should just link to the value at 40 smoothly. Format Axis does not seem to do anything here)

编辑 - 见图

推荐答案

具有平滑线条和标记的散布示例：

Example of Scatter with Smooth Lines and Markers:

正如@Jon Peltier提到的，在此编辑之前，我错误地将上述描述为直线和标记的散点图。

As the @Jon Peltier has kindly mentioned, prior to this edit I had incorrectly described the above as Scatter with Straight Lines and Markers.

Jon也有指出这是怎么一个例子的平滑线路的欺骗的潜力。如果垂直比例是百分比，那么超过100的可能是不可能的，虽然图表中的凹凸将指示其他！

Jon has also pointed out how this happens to be an example of the potential for smooth lines to be deceptive. If the vertical scale were percentages then anything over 100 might not be possible, though the 'bump' in the chart would indicate otherwise!

使用直线线的替代品如下所示，其中显示的B值已更改为表示 sum A和B值，可能更接近OP的要求：

An alternative with Straight lines is shown below, where 'B' values as displayed have been changed to represent the sum of A and B values, as possibly nearer the OP's requirement:

这篇关于在Excel图表中缩放轴的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！