Last updated
You can set format settings about appearance styles, such as colors and icons, to each series value columns and child columns as same as the normal columns.
To set format setting, select "Setting" from the menu in each header and change the style from the "Format" tab in the dialog.
If you set format setting to a particular series value column, the format setting is applied to all child columns corresponding to that series value. If the format setting is done in child columns, the series formatting is overridden.
Conditional formatting is not available for series value column format.
If you set format setting to a particular child column, the style is applied to corresponding child columns in all series values. If you set format in a child column, it will overwrite the format even if you have set format to the series value column.
Like regular columns, child columns can also be conditionally formatted. Also, as with regular columns, it is possible to change the column to be compared in conditional formatting to a column other than the current column, but only child columns belonging to the same matrix column can be compared.
Last updated