Type Alias ChartFieldBinding

How the values run through the range: down columns, or across rows. For a multi-level category range, this also decides whether each level is a column or a row.

A reference to the source cells, for example Sheet1!$B$2:$B$10.

The whole source range when cells are filtered out with Excel's chart filter. If categories are filtered out formula refers to the visible cells only, which can be a list of ranges so evaluating it gives only the visible points. When the whole series is filtered out (ChartSeries.hidden), no cells are visible and there's no formula. When absent, nothing is filtered out.

For multi-level categories, which level of the source range this field holds. Level 0 is the innermost level, the one closest to the axis. All the level fields of a multi-level category share the same formula: one range, with a column per level when direction is column, or a row per level when it's row. Level 0 is the range's last column (or row), next to the values, and outer levels come before it. When absent, the field isn't a level of a multi-level category.

Excel number format code for the field's values. When sourceLinked is true, this is the source cells' format, and a renderer that evaluates the formula takes the format from the cells.

The field's role in the source chart. When absent, the field has no particular role.

Whether the number format follows the source cells.

The field's values, by point index. With a formula, they're only a cache of its result, which can be missing or out of date, and a writer may leave them out. Without a formula, they're literal data.