PutWorksheetChart

Add a new chart in the worksheet.

REST API

API	HttpMethod	Description	API reference
/cells/{name}/worksheets/{sheetName}/charts	PUT	Add a new chart in the worksheet.	PutWorksheetChart

Path Parameter

Parameter Name	Type	Description
name	string	The file name.
sheetName	string	The worksheet name.

Query Parameter

Parameter Name	Type	Description
chartType	string	Chart type	please refer property Type in chart resource.
upperLeftRow	integer	Upper-left row for the new chart.
upperLeftColumn	integer	Upper-left column for the new chart.
lowerRightRow	integer	Lower-left row for the new chart.
lowerRightColumn	integer	Lower-left column for the new chart.
area	string	Specify the values from which to plot the data series.
isVertical	boolean	Specify whether to plot the series from a range of cell values by row or by column.
categoryData	string	Get or set the range of category axis values. It can be a range of cells (e.g.	'D1:E10').
isAutoGetSerialName	boolean	Specify whether to auto-update the serial name.
title	string	Specify the chart title name.
folder	string	The folder where the file is situated.
dataLabels	boolean	Represents the specified chart's data label values display behavior. True to display the values	False to hide them.
dataLabelsPosition	string	Represents data label position (Center/InsideBase/InsideEnd/OutsideEnd/Above/Below/Left/Right/BestFit/Moved).
pivotTableSheet	string	The source is the data of the pivotTable. If PivotSource is not empty	the chart is a PivotChart.
pivotTableName	string	The pivot table name.
storageName	string	The storage name where the file is situated.

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

You can use cURL command-line tool to access Aspose.Cells web services easily. The following example shows how to make calls to Cloud API with cURL.

Request


curl -v "https://api.aspose.cloud/v3.0/cells/cells/Book1.xlsx/worksheets/Sheet4/charts?chartType=Pie&upperLeftRow=5&upperLeftColumn=5&lowerRightRow=10&lowerRightColumn=10&area=C7:D11&isVertical=true&title=Aspose Chart&folder=TestData/In"
    -X PUT 
    -H "Authorization: Bearer \<jwt token> " \

Cloud SDK Family

Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

PutWorksheetChart

PutWorksheetChart

Add a new chart in the worksheet.

REST API

Path Parameter

Query Parameter

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

You can use cURL command-line tool to access Aspose.Cells web services easily. The following example shows how to make calls to Cloud API with cURL.

Cloud SDK Family

Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to make calls to Aspose.Cells web services using various SDKs: