> For the complete documentation index, see [llms.txt](https://docs.mashmatrix.com/mashmatrix-sheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/change_matrix_column_setting.md).

# Change Matrix Column Setting

Follow the procedure below to change the settings of the added matrix column.

1. Select "Setting" from the matrix column header menu.
2. Column Setting dialog will be displayed with three tabs of "Basic Property", "Series" and "Child Column".

## Basic Property

![](/files/9w8DVs1vx6gOKqBcceLp)

Unlike normal column setting dialog, you can only change the settings for the header label.

## Series

![](/files/PjSce0ygXHLT25jbHdIK)

In the Series tab, you can change settings related to the matrix column series.

* **\[A] Display Interval** - Change the display interval of time series items. Select from the following values:
  * Yearly
  * Quarterly
  * Monthly
  * Weekly
  * Daily
* **\[B] Start** - Set the first date of the time series to display. You can specify a date directly from the calendar, but you can also select relative dates (e.g., "Today", "Next Month"). You can also use the **Reference Value Selection Button \[※]** to select reference values and dynamically change setting values. For details on reference values, see "[Reference Value](/mashmatrix-sheet/functions_about_displaying_data/reference_value.md)".
* **\[C] Period** - Specify the period to display time series as a numerical value. Must specify an integer value of 1 or greater. You can also use the **Reference Value Selection Button \[※]** to select reference values and dynamically change setting values. For details on reference values, see "[Reference Value](/mashmatrix-sheet/functions_about_displaying_data/reference_value.md)".
* **\[D] Date Format** - By setting a date format, you can automatically generate series display labels in the specified format. This is particularly useful when start dates or periods change dynamically. Checking **Specify header display labels individually \[E]** allows you to customize series display labels individually.
* **\[F] Series Menu** - Toggle the display/hide settings for series (hidden series values are displayed with grayed text)

## Child Columns

![](/files/cfWuRsl0sFhVoFAcWC9h)

You can check the child columns to be displayed inside the matrix column. It is also possible to hide each child column, or make the hidden child columns visible (hidden child columns are displayed with grayed text).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/change_matrix_column_setting.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.