title	Chart: setPosition
description	Positions the chart relative to cells on the worksheet.
author	lumine2008
ms.localizationpriority	medium
ms.subservice	excel
doc_type	apiPageType
ms.date	04/04/2024

Chart: setPosition

Namespace: microsoft.graph

Positions the chart relative to cells on the worksheet.

[!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}/setPosition
POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setPosition

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
startCell	Json	The start cell. This is where the chart is moved to. The start cell is the top-left or top-right cell, depending on the user's right-to-left display settings.
endCell	Json	Optional. The end cell. If specified, the chart's width and height will be set to fully cover up this cell/range.

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}/setPosition
Content-type: application/json

{
  "startCell": "startCell-value",
  "endCell": "endCell-value"
}