[]
Specifies the scale type for a chart value axis.
Use this enum with ScaleType to control whether the value axis uses linear or logarithmic scaling. When Logarithmic is used, you can configure the logarithmic base through LogBase.
public enum ScaleType
Public Enum ScaleType
worksheet.Range["A1:B4"].Value = new object[,] {
{"Month", "Sales"},
{"Jan", 10},
{"Feb", 100},
{"Mar", 1000}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
IAxis valueAxis = shape.Chart.Axes.Item(AxisType.Value);
valueAxis.ScaleType = ScaleType.Logarithmic;
valueAxis.LogBase = 10;
| Name | Description |
|---|---|
| Linear | Specifies the linear scale. |
| Logarithmic | Specifies the logarithmic scale. |