workbookvisualization

This configuration is optional when using the plugin Cadenza.

  • Documentation

  • YAML Format

  • XML Format

Fill relevant inputs (blue boxes) and click the blue bars on the left to copy XML configuration snippets.
<workbookVisualizationConfiguration
>
required
<colorConfiguration
<colorPalette
id
required
=
string
<title
>
required
string
</title>
<color
>
requiredmax. unbounded
string
</color>
>
optionalmax. unbounded
</colorPalette>
<colorPalettes
<colorPalette
refId
optional
=
string
>
requiredmax. unbounded
</colorPalette>
>
optional
</colorPalettes>
<gradient
id
required
=
string
<title
>
required
string
</title>
<colorPalette
refId
optional
=
string
>
required
</colorPalette>
>
optionalmax. unbounded
</gradient>
<gradients
<gradientGroup
<title
>
required
string
</title>
<gradient
refId
optional
=
string
>
requiredmax. unbounded
</gradient>
>
requiredmax. unbounded
</gradientGroup>
>
optional
</gradients>
<heatmapGradients
<gradientGroup
<title
>
required
string
</title>
<gradient
refId
optional
=
string
>
requiredmax. unbounded
</gradient>
>
requiredmax. unbounded
</gradientGroup>
>
optional
</heatmapGradients>
<backgroundColorPalette
refId
optional
=
string
>
optional
</backgroundColorPalette>
<textColorPalette
refId
optional
=
string
>
optional
</textColorPalette>
<defaultBulletChartGradient
refId
optional
=
string
>
optional

Provides a default gradient for bullet-charts. The gradient is used to derive the background colors for the chart. Can be overridden by the customer.

</defaultBulletChartGradient>
>
optional
</colorConfiguration>
</workbookVisualizationConfiguration>
This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not.
cadenzaconfig:
  settings:
    workbookvisualization:
      colorConfiguration:
        colorPalette:
        - id: "text"
          title: "text"
          color:
          - "text"
          - "text"
        - id: "text"
          title: "text"
          color:
          - "text"
          - "text"
        colorPalettes:
        - refId: "text"
        - refId: "text"
        gradient:
        - id: "text"
          title: "text"
          colorPalette:
            refId: "text"
        - id: "text"
          title: "text"
          colorPalette:
            refId: "text"
        gradients:
        - title: "text"
          gradient:
          - refId: "text"
          - refId: "text"
        - title: "text"
          gradient:
          - refId: "text"
          - refId: "text"
        heatmapGradients:
        - title: "text"
          gradient:
          - refId: "text"
          - refId: "text"
        - title: "text"
          gradient:
          - refId: "text"
          - refId: "text"
        backgroundColorPalette:
          refId: "text"
        textColorPalette:
          refId: "text"
        defaultBulletChartGradient:
          refId: "text"

Filename: workbookvisualization-config.xml

This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<workbookVisualizationConfiguration>
  <colorConfiguration>
    <colorPalette id="text">
      <title>text</title>
      <color>text</color>
      <color>text</color>
    </colorPalette>
    <colorPalette id="text">
      <title>text</title>
      <color>text</color>
      <color>text</color>
    </colorPalette>
    <colorPalettes>
      <colorPalette refId="text"/>
      <colorPalette refId="text"/>
    </colorPalettes>
    <gradient id="text">
      <title>text</title>
      <colorPalette refId="text"/>
    </gradient>
    <gradient id="text">
      <title>text</title>
      <colorPalette refId="text"/>
    </gradient>
    <gradients>
      <gradientGroup>
        <title>text</title>
        <gradient refId="text"/>
        <gradient refId="text"/>
      </gradientGroup>
      <gradientGroup>
        <title>text</title>
        <gradient refId="text"/>
        <gradient refId="text"/>
      </gradientGroup>
    </gradients>
    <heatmapGradients>
      <gradientGroup>
        <title>text</title>
        <gradient refId="text"/>
        <gradient refId="text"/>
      </gradientGroup>
      <gradientGroup>
        <title>text</title>
        <gradient refId="text"/>
        <gradient refId="text"/>
      </gradientGroup>
    </heatmapGradients>
    <backgroundColorPalette refId="text"/>
    <textColorPalette refId="text"/>
    <defaultBulletChartGradient refId="text"/>
  </colorConfiguration>
</workbookVisualizationConfiguration>