Excel.Interfaces.ChartAxisUpdateData interface
An interface for updating data on the ChartAxis object, for use in chartAxis.set({ ... }).
| alignment | Specifies the alignment for the specified axis tick label. See |
| 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. |
| is |
Specifies if the value axis crosses the category axis between categories. |
| link |
Specifies if the number format is linked to the cells. If |
| 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. |
| multi |
Specifies if an axis is multilevel. |
| number |
Specifies the format code for the axis tick label. |
| offset | Specifies the distance between the levels of labels, and the distance between the first level and the axis line. The value should be an integer from 0 to 1000. |
| position | Specifies the specified axis position where the other axis crosses. See |
| 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. |
| text |
Specifies the angle to which the text is oriented for the chart axis tick label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text. |
| 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. |
Specifies the alignment for the specified axis tick label. See Excel.ChartTextHorizontalAlignment for detail.
alignment?: Excel.ChartTickLabelAlignment | "Center" | "Left" | "Right";Property Value
Excel.ChartTickLabelAlignment | "Center" | "Left" | "Right"
Remarks
Specifies the base unit for the specified category axis.
baseTimeUnit?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";Property Value
Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"
Remarks
Specifies the category axis type.
categoryType?: Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis";Property Value
Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis"
Remarks
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
Represents the formatting of a chart object, which includes line and font formatting.
format?: Excel.Interfaces.ChartAxisFormatUpdateData;Property Value
Remarks
Specifies if the value axis crosses the category axis between categories.
isBetweenCategories?: boolean;Property Value
boolean
Remarks
Specifies if the number format is linked to the cells. If true, the number format will change in the labels when it changes in the cells.
linkNumberFormat?: boolean;Property Value
boolean
Remarks
Specifies the base of the logarithm when using logarithmic scales.
logBase?: number;Property Value
number
Remarks
Returns an object that represents the major gridlines for the specified axis.
majorGridlines?: Excel.Interfaces.ChartGridlinesUpdateData;Property Value
Remarks
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
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
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
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
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
Returns an object that represents the minor gridlines for the specified axis.
minorGridlines?: Excel.Interfaces.ChartGridlinesUpdateData;Property Value
Remarks
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
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
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
Specifies if an axis is multilevel.
multiLevel?: boolean;Property Value
boolean
Remarks
Specifies the format code for the axis tick label.
numberFormat?: string;Property Value
string
Remarks
Specifies the distance between the levels of labels, and the distance between the first level and the axis line. The value should be an integer from 0 to 1000.
offset?: number;Property Value
number
Remarks
Specifies the specified axis position where the other axis crosses. See Excel.ChartAxisPosition for details.
position?: Excel.ChartAxisPosition | "Automatic" | "Maximum" | "Minimum" | "Custom";Property Value
Excel.ChartAxisPosition | "Automatic" | "Maximum" | "Minimum" | "Custom"
Remarks
Specifies if Excel plots data points from last to first.
reversePlotOrder?: boolean;Property Value
boolean
Remarks
Specifies the value axis scale type. See Excel.ChartAxisScaleType for details.
scaleType?: Excel.ChartAxisScaleType | "Linear" | "Logarithmic";Property Value
Excel.ChartAxisScaleType | "Linear" | "Logarithmic"
Remarks
Specifies if the axis display unit label is visible.
showDisplayUnitLabel?: boolean;Property Value
boolean
Remarks
Specifies the angle to which the text is oriented for the chart axis tick label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text.
textOrientation?: any;Property Value
any
Remarks
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
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
Specifies the number of categories or series between tick marks.
tickMarkSpacing?: number;Property Value
number
Remarks
Represents the axis title.
title?: Excel.Interfaces.ChartAxisTitleUpdateData;Property Value
Remarks
Specifies if the axis is visible.
visible?: boolean;Property Value
boolean
Remarks
Office Add-ins feedback
Office Add-ins is an open source project. Select a link to provide feedback: