The XL3SetProperty formula updates the Anaplan XL chart properties in the workbook
You reference the chart to be affected using its chart name. This can be seen when you select the chart - the chart name is then shown in the box above cell A1 (the same place as named ranges).
| Property | Description | Value |
| YMin or YMax | Sets the limits of the Y Axis. | Numeric) |
| Y2Min or Y2Max | Sets the limits of the Y2 Axis. | Numeric |
| XMin or XMax | Sets the limits of the X Axis. | Numeric |
| X2Min or X2Max | Sets the limits of the X2 Axis. | Numeric |
| YMajorUnit / YMinorUnit | Sets the units of the Y Axis. | Numeric or auto. Also works for other axes. |
| Visible | Sets the chart's visibility. | TRUE or FALSE |
| SeriesFillColor | Sets the series' color. | Numeric values for series index an HTML color value (#RRGGBB) or a named color. |
| SeriesBorderColor | Sets the series' color. | Numeric values for series index and HTML color value (#RRGGBB) or a named color. |
| XCrosses, YCrosses, X2Crosses, Y2Crosses | Sets the axis crossing point. | Numeric value for custom settings, or auto, min, max to cross at those positions. |
| SeriesDataLabels | Updates the series' data labels from a range. | Pass 2 parameters: the zero-based index of the data series to update and an XL3Address formula for the range to use (must be on the same worksheet) |
