Additional data

  • 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 you can use additional_data to insert custom values directly into specific cells of the chart’s internal data table.

  • Each cell_target defines the starting cell where the data will be written.

  • additional_data is independent from the main chart dataset. It’s used to fill or override specific cells in the underlying Excel sheet of the chart — for example, adding helper values, metadata, or computed fields without affecting the main chart series.

Reference: chart

Download: input.zip | output.pptx


{
    "presentation": {
        "template_list": [
            {
                "template_id": 1454,
                "template_name": "template.pptx"
            }
        ],
        "slides": [
            {
                "slide_index": 0,
                "template_id": 1454,
                "shapes": [
                    {
                        "name": "Chart 5",
                        "additional_data": [
                            {
                                "cell_target": "B22",
                                "data": [
                                    [
                                        0.2,
                                        0.3,
                                        0.35
                                    ],
                                    [
                                        0.4,
                                        0.5,
                                        "0.45%"
                                    ]
                                ]
                            },
                            {
                                "cell_target": "A2",
                                "data": [
                                    [
                                        " ",
                                        35,
                                        0.6
                                    ],
                                    [
                                        "maj",
                                        0.5,
                                        58
                                    ]
                                ]
                            },
                            {
                                "cell_target": "A4",
                                "data": [
                                    [
                                        "Category 3",
                                        5,
                                        10
                                    ]
                                ]
                            },
                            {
                                "cell_target": "AA5",
                                "data": [
                                    [
                                        0.5,
                                        0.2
                                    ],
                                    [
                                        0.455,
                                        0.7234
                                    ]
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    }
}

Last updated

Was this helpful?