XY (Scatter) Chart Preset

Dot Plot 3x

Dot Plot 3x is an OPF xy (scatter) chart preset with canonical workbook metadata, sample data, and engine chart type mapping.

dot-plot-3xOPF type: SERIES_OF_MIXED_TYPEScalculated

Use Case

Explore relationships between two numeric variables or compare many points without bars.

Data Requirements

3 series, 8 categories, calculated helper workbook, 2 series groups

Group

Point-based relationship charts for correlation, distribution, and paired measures.

Series

3 series across 8 categories

Workbook Range

Sheet1!$A$1:$I$6

Source Slide

Slide 36 in the OPF chart gallery deck

When to Use

Use for correlation, outlier detection, and paired-value analysis.

When to Avoid

Avoid when the audience needs a simple ranked comparison or when points cannot be labeled clearly.

Best Practices

1

Explain both axes clearly

2

Highlight outliers intentionally

3

Avoid overplotting with too many points

Recommended Companions

OPF Config

charts:dot-plot-3x
Open Presentation Format
{
  "$schema": "https://pptx.dev/schema/opf/v1",
  "version": "1.0",
  "meta": {
    "title": "PPTX.gallery — charts/dot-plot-3x"
  },
  "design": {},
  "slides": [
    {
      "id": "gallery-preview-1",
      "layout": "chart",
      "elements": [
        {
          "id": "gallery-chart-1",
          "type": "chart",
          "chartPreset": "dot-plot-3x",
          "data": {
            "labels": [
              "Item 1",
              "Item 2",
              "Item 3",
              "Item 4",
              "Item 5",
              "Item 6",
              "Item 7",
              "Item 8"
            ],
            "datasets": [
              {
                "label": "2020",
                "values": [
                  466960,
                  335113,
                  171951,
                  142213,
                  132537,
                  359295,
                  309044,
                  121369
                ]
              },
              {
                "label": "2021",
                "values": [
                  259784,
                  350132,
                  232352,
                  596564,
                  219946,
                  691364,
                  328552,
                  587623
                ]
              },
              {
                "label": "2022",
                "values": [
                  368690,
                  486814,
                  275939,
                  220096,
                  271720,
                  426147,
                  213349,
                  126925
                ]
              }
            ]
          }
        }
      ]
    }
  ]
}
Open in OPF Playground

Preview this config live at pptx.dev/playground.