title	Chart: setData
description	Resets the source data for the chart.
author	lumine2008
ms.localizationpriority	medium
ms.subservice	excel
doc_type	apiPageType
ms.date	04/04/2024

Chart: setData

Namespace: microsoft.graph

Resets the source data for the chart.

[!INCLUDE national-cloud-support]

Permissions

Choose the permission or permissions marked as least privileged for this API. Use a higher privileged permission or permissions only if your app requires it. For details about delegated and application permissions, see Permission types. To learn more about these permissions, see the permissions reference.

[!INCLUDE permissions-table]

HTTP request

POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setData
POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setData

Request headers

Name	Description
Authorization	Bearer {token}. Required. Learn more about authentication and authorization.
Workbook-Session-Id	Workbook session Id that determines if changes are persisted or not. Optional.

Request body

In the request body, provide a JSON object with the following parameters.

Parameter	Type	Description
sourceData	Json	The Range object corresponding to the source data.
seriesBy	string	Optional. Specifies the way columns or rows are used as data series on the chart. Can be one of the following: Auto (default), Rows, Columns. The possible values are: `Auto`, `Columns`, `Rows`.

Response

If successful, this method returns 200 OK response code. It doesn't return anything in the response body.

Example

Here's an example of how to call this API.

Request

The following example shows a request.

HTTP

POST https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setData
Content-type: application/json

{
  "sourceData": "sourceData-value",
  "seriesBy": "seriesBy-value"
}