Set as Total - Waterfall chart

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

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

Reference: chart

Download: input.ziparrow-up-right | output.pptxarrow-up-right


{
  "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
                }
              ]
            }
          }
        ]
      }
    ]
  }
}

Last updated