The XL3SetProperty formula updates the Anaplan XL grid display and permission properties in the workbook
| Property | Description | Value |
| RemoveEmptyCategories | Sets the categories to hide or show members with no data. | TRUE or FALSE |
| RemoveEmptySeries | Sets the series to hide or show members with no data. | TRUE or FALSE |
| RemoveEmptyColumns | Sets the columns to hide or show members with no data. | TRUE or FALSE |
| RemoveEmptyRows | Sets the rows to hide or show members with no data. | TRUE or FALSE |
| HierarchiesOnCategories | Sets hierarchies for categories. Will move hierarchies as required. | Hierarchy name or names. |
| HierarchiesOnSeries | Sets hierarchies on series. Will move hierarchies as required. | Hierarchy name or names. |
| HierarchiesOnColumns | Sets hierarchies on columns. Will move hierarchies as required. | Hierarchy name or names. |
| HierarchiesOnRows | Sets hierarchies on rows. Will move hierarchies as required. | Hierarchy name or names. |
| HierarchiesOnHeaders | Sets hierarchies on headers. Will move hierarchies as required. | Hierarchy name or names. |
| MemberSelectionType | Sets the selection type of the members, for example children, parent, descendants etc. | Review the Member Selection Type section for more details. |
| ChartType | Sets chart type of the series. | Valid values are Column, StackedColumn, StackedColumn100, Bar, StackedBar, StackedBar100, Area, StackedArea, StackedArea100, Line. |
| ChartType2 | Sets chart type of the series once moved to the secondary axis. | Same as ChartType. |
| DataLabelsVisible | Shows or hides the data labels. | TRUE or FALSE |
| Visible | Sets the chart visibility. | TRUE or FALSE |
| ClearHighlights | Clear the current chart highlights, requires a toggle cell as the value argument which is reset after the highlights are cleared. =XL3SetProperty(SmallMultiple, test, ClearHighlights, A1) Review XL3RunSQL for an example of setting up a trigger cell. | A cell containing FALSE, which is set to TRUE by an XL3Link. |
