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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for