Combo Chart Preset

Combo: Column and Line

Combo: Column and Line is an OPF combo chart preset: clustered columns with a line series, the line on a secondary value axis in its own number format.

comboOPF type: CLUSTERED_COLUMN_LINEsimple
Combo: Column and Line chart preview rendered from its OPF sample

Use Case

Show an amount and a rate for the same categories, such as revenue and margin by quarter.

Data Requirements

2 or more series, 4 categories; the last series (or the ones chart.line names) is drawn as a line, chart.secondaryAxis moves it to a right-hand axis

Group

Combo

Series

2 series across 4 categories

Workbook Range

Sheet1!$A$1:$E$3

When to Use

Use when two measures share the categories but not the unit, so one value axis would flatten the smaller measure.

When to Avoid

Avoid when both measures share a unit and scale (use a clustered column or line chart), or when more than one or two lines would crowd the columns.

Series colors

By default a chart takes its series colors from the deck's color scheme. Series 1 to 6 use accent1 to accent6 of the scheme in that order; series 7 to 12 use the same six accents mixed 40% toward white (series 7 is a tint of accent1). A pie, doughnut, treemap or funnel gives category i color i. Charts with more than twelve series repeat the list.

Put the series that carries the message first, because accent1 is the deck's primary, and keep a chart to six series or fewer so no tint is needed. Each color is then adjusted so it keeps 3:1 contrast against the chart panel and stays apart from its neighbours; on a dark panel colors are lightened, never merged.

To set a series color yourself, give the chart chart.colors: a list of up to 24 colors by position, where entry i replaces the palette color of series (or slice, for a pie) i and the rest of the palette is unchanged. An entry is any ColorRef: a hex color, a color-scheme slot or role such as accent3 (it follows the deck if its scheme changes), or a var: color variable. The contrast adjustment still applies to authored colors, and the opf/chart-colors-adjusted warning says when an entry was unresolvable or had to be moved.

"chart": {
  "type": "column",
  "data": { "columns": ["Quarter", "Revenue", "Costs"], "rows": [["Q1", 12, 8], ["Q2", 18, 11]] },
  "colors": ["accent3", "#7B241C"]
}

highlight wins over both: the series and categories it names take the deck's primary color and every other mark takes a muted neutral, whatever chart.colors says.

Core 0.21.0 behavior.

Best Practices

1

Put the rate on the secondary axis and give it a percent format

2

Title both value axes

3

Keep one or two line series

Recommended Companions

OPF Config

charts:combo
OPF JSON
{
  "$schema": "https://openpresentation.org/schema/opf/v1",
  "name": "PPTX.gallery — charts/combo",
  "description": "Combo: Column and Line is an OPF combo chart preset: clustered columns with a line series, the line on a secondary value axis in its own number format.",
  "tags": [
    "gallery:charts/combo"
  ],
  "slides": [
    {
      "id": "gallery-preview-1",
      "layout": "chart",
      "title": "Combo: Column and Line",
      "subtitle": "Show an amount and a rate for the same categories, such as revenue and margin by quarter.",
      "chart": {
        "type": "combo",
        "data": {
          "columns": [
            "Category",
            {
              "name": "Revenue",
              "format": "$#,##0.0"
            },
            {
              "name": "Margin",
              "format": "0%"
            }
          ],
          "rows": [
            [
              "Q1 2025",
              12.4,
              0.31
            ],
            [
              "Q2 2025",
              18.1,
              0.34
            ],
            [
              "Q3 2025",
              21.7,
              0.29
            ],
            [
              "Q4 2025",
              26.3,
              0.37
            ]
          ]
        },
        "line": [
          "Margin"
        ],
        "secondaryAxis": [
          "Margin"
        ]
      }
    }
  ],
  "catalogs": {
    "default": {
      "source": "https://www.pptx.gallery",
      "layouts": {
        "chart": {
          "name": "Chart",
          "summary": "One to six charts, with an optional note.",
          "tags": [
            "Visuals"
          ],
          "direction": "column",
          "regions": [
            {
              "name": "title"
            },
            {
              "name": "charts",
              "accepts": [
                "chart",
                "group",
                "diagram"
              ],
              "role": "primary",
              "flow": "grid"
            },
            {
              "name": "note",
              "size": "auto",
              "accepts": [
                "text"
              ],
              "role": "supporting",
              "flow": "none"
            }
          ],
          "description": "Give a chart enough space to show its evidence. Use the title to state the conclusion and labels to explain the measures.",
          "preview": {
            "vectorSrc": "https://www.pptx.gallery/layout-previews/chart.svg"
          }
        }
      }
    }
  }
}
Open in visual editorOpen in Inspector

Load this config in the gallery's visual editor, or in the Inspector at pptx.dev.