Excel.Interfaces.ChartAxisUpdateData interface
An interface for updating data on the ChartAxis
object, for use in chartAxis.set({ ... })
.
Properties
base |
Specifies the base unit for the specified category axis. |
category |
Specifies the category axis type. |
display |
Represents the axis display unit. See |
format | Represents the formatting of a chart object, which includes line and font formatting. |
log |
Specifies the base of the logarithm when using logarithmic scales. |
major |
Returns an object that represents the major gridlines for the specified axis. |
major |
Specifies the type of major tick mark for the specified axis. See |
major |
Specifies the major unit scale value for the category axis when the |
major |
Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number. |
maximum | Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number. |
minimum | Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number. |
minor |
Returns an object that represents the minor gridlines for the specified axis. |
minor |
Specifies the type of minor tick mark for the specified axis. See |
minor |
Specifies the minor unit scale value for the category axis when the |
minor |
Represents the interval between two minor tick marks. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number. |
reverse |
Specifies if Excel plots data points from last to first. |
scale |
Specifies the value axis scale type. See |
show |
Specifies if the axis display unit label is visible. |
tick |
Specifies the position of tick-mark labels on the specified axis. See |
tick |
Specifies the number of categories or series between tick-mark labels. Can be a value from 1 through 31999 or an empty string for automatic setting. The returned value is always a number. |
tick |
Specifies the number of categories or series between tick marks. |
title | Represents the axis title. |
visible | Specifies if the axis is visible. |
Property Details
baseTimeUnit
Specifies the base unit for the specified category axis.
baseTimeUnit?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";
Property Value
Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"
Remarks
categoryType
Specifies the category axis type.
categoryType?: Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis";
Property Value
Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis"
Remarks
displayUnit
Represents the axis display unit. See Excel.ChartAxisDisplayUnit
for details.
displayUnit?: Excel.ChartAxisDisplayUnit | "None" | "Hundreds" | "Thousands" | "TenThousands" | "HundredThousands" | "Millions" | "TenMillions" | "HundredMillions" | "Billions" | "Trillions" | "Custom";
Property Value
Excel.ChartAxisDisplayUnit | "None" | "Hundreds" | "Thousands" | "TenThousands" | "HundredThousands" | "Millions" | "TenMillions" | "HundredMillions" | "Billions" | "Trillions" | "Custom"
Remarks
format
Represents the formatting of a chart object, which includes line and font formatting.
format?: Excel.Interfaces.ChartAxisFormatUpdateData;
Property Value
Remarks
logBase
Specifies the base of the logarithm when using logarithmic scales.
logBase?: number;
Property Value
number
Remarks
majorGridlines
Returns an object that represents the major gridlines for the specified axis.
majorGridlines?: Excel.Interfaces.ChartGridlinesUpdateData;
Property Value
Remarks
majorTickMark
Specifies the type of major tick mark for the specified axis. See Excel.ChartAxisTickMark
for details.
majorTickMark?: Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside";
Property Value
Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside"
Remarks
majorTimeUnitScale
Specifies the major unit scale value for the category axis when the categoryType
property is set to dateAxis
.
majorTimeUnitScale?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";
Property Value
Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"
Remarks
majorUnit
Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number.
majorUnit?: any;
Property Value
any
Remarks
maximum
Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
maximum?: any;
Property Value
any
Remarks
minimum
Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minimum?: any;
Property Value
any
Remarks
minorGridlines
Returns an object that represents the minor gridlines for the specified axis.
minorGridlines?: Excel.Interfaces.ChartGridlinesUpdateData;
Property Value
Remarks
minorTickMark
Specifies the type of minor tick mark for the specified axis. See Excel.ChartAxisTickMark
for details.
minorTickMark?: Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside";
Property Value
Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside"
Remarks
minorTimeUnitScale
Specifies the minor unit scale value for the category axis when the categoryType
property is set to dateAxis
.
minorTimeUnitScale?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";
Property Value
Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"
Remarks
minorUnit
Represents the interval between two minor tick marks. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minorUnit?: any;
Property Value
any
Remarks
reversePlotOrder
Specifies if Excel plots data points from last to first.
reversePlotOrder?: boolean;
Property Value
boolean
Remarks
scaleType
Specifies the value axis scale type. See Excel.ChartAxisScaleType
for details.
scaleType?: Excel.ChartAxisScaleType | "Linear" | "Logarithmic";
Property Value
Excel.ChartAxisScaleType | "Linear" | "Logarithmic"
Remarks
showDisplayUnitLabel
Specifies if the axis display unit label is visible.
showDisplayUnitLabel?: boolean;
Property Value
boolean
Remarks
tickLabelPosition
Specifies the position of tick-mark labels on the specified axis. See Excel.ChartAxisTickLabelPosition
for details.
tickLabelPosition?: Excel.ChartAxisTickLabelPosition | "NextToAxis" | "High" | "Low" | "None";
Property Value
Excel.ChartAxisTickLabelPosition | "NextToAxis" | "High" | "Low" | "None"
Remarks
tickLabelSpacing
Specifies the number of categories or series between tick-mark labels. Can be a value from 1 through 31999 or an empty string for automatic setting. The returned value is always a number.
tickLabelSpacing?: any;
Property Value
any
Remarks
tickMarkSpacing
Specifies the number of categories or series between tick marks.
tickMarkSpacing?: number;
Property Value
number
Remarks
title
Represents the axis title.
title?: Excel.Interfaces.ChartAxisTitleUpdateData;
Property Value
Remarks
visible
Specifies if the axis is visible.
visible?: boolean;
Property Value
boolean
Remarks
Office Add-ins