PARETO

{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "pareto",
  "name": "PARETO",
  "label": "Pareto",
  "mappings": {
    "openxml": {
      "composition": "mixed",
      "series": [
        {
          "element": "barChart",
          "barDir": "col",
          "grouping": "clustered",
          "composition": "single"
        },
        {
          "element": "lineChart",
          "composition": "single"
        }
      ],
      "notes": "Pareto charts combine sorted columns with a cumulative-percentage line."
    }
  },
  "categories": 49,
  "columns": [
    "Category",
    "Series1"
  ],
  "group": "Histogram",
  "groupSort": 9,
  "series": 1,
  "seriesGroups": 2,
  "slideNumber": 47,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$AX$2",
  "complexity": "simple",
  "dataColumns": [
    {
      "name": "Category",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Series1",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    }
  ],
  "sampleData": {
    "headers": [
      "Category",
      "Cat 1",
      "Cat 2",
      "Cat 3",
      "Cat 4",
      "Cat 5",
      "Cat 6",
      "Cat 7",
      "Cat 8",
      "Cat 9",
      "Cat 10",
      "Cat 11",
      "Cat 12",
      "Cat 13",
      "Cat 14",
      "Cat 15",
      "Cat 16",
      "Cat 17",
      "Cat 18",
      "Cat 19",
      "Cat 20",
      "Cat 21",
      "Cat 22",
      "Cat 23",
      "Cat 24",
      "Cat 25",
      "Cat 26",
      "Cat 27",
      "Cat 28",
      "Cat 29",
      "Cat 30",
      "Cat 31",
      "Cat 32",
      "Cat 33",
      "Cat 34",
      "Cat 35",
      "Cat 36",
      "Cat 37",
      "Cat 38",
      "Cat 39",
      "Cat 40",
      "Cat 41",
      "Cat 42",
      "Cat 43",
      "Cat 44",
      "Cat 45",
      "Cat 46",
      "Cat 47",
      "Cat 48",
      "Cat 49"
    ],
    "rows": [
      [
        "Series1",
        49857,
        62757,
        45683,
        75597,
        80776,
        74722,
        67377,
        20543,
        88385,
        15224,
        66626,
        52247,
        89129,
        42816,
        13390,
        21970,
        40005,
        98381,
        85392,
        86955,
        12719,
        98117,
        45325,
        85529,
        15273,
        32962,
        71669,
        78021,
        95394,
        67963,
        46458,
        33788,
        86720,
        67132,
        93202,
        74451,
        21959,
        71605,
        55607,
        63523,
        53687,
        52081,
        97835,
        23710,
        31079,
        53228,
        63955,
        74942,
        47777
      ]
    ]
  }
}