Set as Total

• Select the shape by name you want to modify. See here to find shape names.

• Specify the chart title under title, if necessary.

• Under data:

  • The first array contains the list of series labels (e.g. "Series 1").

  • The second array contains the list of categories (e.g. "Item 1", "Item 2", "Total").

  • Each following array represents the series values for each category, in order.

• Use the settings field to define which data points should be treated as totals by setting the set_as_total property to true.

Reference:

Download: input.zip | output.pptx

---

{
  "presentation": {
    "template": "template.pptx",
    "slides": [
      {
        "slide_index": 0,
        "shapes": [
          {
            "name": "waterfallChart",
            "data": [
              ["Series 1"],
              [
                "Item 1",
                "Item 2",
                "Item 3",
                "Item 4",
                "Item 5",
                "Total"
              ],
              [1],
              [2],
              [3],
              [4],
              [5],
              [15]
            ],
            "settings": {
              "datapoints": [
                {
                  "seriesIndex": 0,
                  "categoryIndex": 2,
                  "set_as_total": true
                },
                {
                  "seriesIndex": 0,
                  "categoryIndex": 0,
                  "set_as_total": true
                }
              ]
            }
          }
        ]
      }
    ]
  }
}