> ## Documentation Index
> Fetch the complete documentation index at: https://docs.reducto.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Types: layout and fonts: Charts and sparklines

## `SparkEmpty`

Hidden & Empty Cells: a gap, zero, or a line across.

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type SparkEmpty = "gap" | "zero" | "span"
```

## `SparkGroupState`

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `color` | `string \| null` | "RRGGBB", or null when the color is a theme color. |
| `count` | `number` | |
| `data` | `string` | Edit Data's ranges: the box of every source, and of every sparkline cell. |
| `empty` | `SparkEmpty` | |
| `hidden` | `boolean` | |
| `kind` | `SparkKind` | |
| `location` | `string` | |
| `markerColor` | `string \| null` | |
| `max` | `SparkScale` | |
| `min` | `SparkScale` | |
| `points` | `Record<SparkPoint, boolean>` | |
| `rightToLeft` | `boolean` | |
| `showAxis` | `boolean` | |
| `style` | `number \| null` | The Style gallery's pick (1-36), or null when the colors match none. |

## `SparkKind`

Line, Column or Win/Loss, as `x14:sparklineGroup/@type` writes them.

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type SparkKind = "line" | "column" | "stacked"
```

## `SparkPoint`

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type SparkPoint = typeof SPARK_POINTS[number]
```

## `SparkScale`

A vertical axis end: each sparkline's own, the group's, or a fixed value.

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type SparkScale = { type: "individual" | "group" } | { type: "custom"; value: number }
```

## `SparkSet`

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `color?` | `string` | |
| `empty?` | `SparkEmpty` | |
| `hidden?` | `boolean` | |
| `kind?` | `SparkKind` | |
| `markerColor?` | `string` | |
| `max?` | `SparkScale` | |
| `min?` | `SparkScale` | |
| `points?` | `Partial<Record<"first" \| "high" \| "low" \| "negative" \| "last" \| "markers", boolean>>` | |
| `rightToLeft?` | `boolean` | |
| `showAxis?` | `boolean` | |
| `style?` | `number` | A Style gallery pick, 1-36; its colors go in before `color` and `markerColor`. |
