平滑線のプロパティ

線を表示するグラフ (折れ線タイプまたは散布図タイプ) では、直線の代わりに曲線を表示することを選択できます。 一部のオプションは、これらの曲線のプロパティを制御します。

このコマンドの見つけ方

In the Chart Type dialog of a Line chart or XY chart that displays lines, choose Stepped in the Lines type drop-down, then click the Properties button.


Line properties

Line type

「3 次元スプライン」または「B スプライン」を選択します。

These are mathematical models that influence the display of the curves. The curves are created by joining together segments of polynomials.

Cubic Spline interpolates your data points with polynomials of degree 3. The transitions between the polynomial pieces are smooth, having the same slope and curvature.

B-Spline uses a parametric, interpolating B-spline curve. Those curves are built piecewise from polynomials.

Resolution

The Resolution determines how many line segments are calculated to draw a piece of polynomial between two data points. You can see the intermediate points if you click any data point.

A higher value leads to a smoother line.

Degree of polynomials

For B-spline lines optionally set the degree of the polynomials.

ご支援をお願いします!