Update Chart Second Category Axis – Aspose.Cells Cloud API

This REST API updates the second category axis of a chart.

PostChartSecondCategoryAxis API

POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/secondcategoryaxis

Security and Authentication

The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.

Request parameters

Parameter Name	Type	Location	Description
name	string	path	The name of the Excel file.
sheetName	string	path	The worksheet name that contains the chart.
chartIndex	integer	path	The zero‑based index of the chart to be updated.
axis	object	body	The second‑category‑axis object with the new settings.
folder	string	query	The folder path where the file is stored.
storageName	string	query	The name of the storage service.

Authentication – The API requires a valid OAuth 2.0 access token. Generate a JWT token by following the Authentication Guide. Include the token in the Authorization header as shown in the cURL example below.

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

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

Request

curl -v "https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/secondcategoryaxis?folder={folder}&storageName={storageName}" \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>" \
  -d '{ 
        "axis": {
          /* axis settings, e.g., "Title": "New Axis Title", "IsVisible": true */
        }
      }'

Replace {name}, {sheetName}, {chartIndex}, {folder}, and {storageName} with your actual values. The request body must contain the axis object with the desired settings.

Response

Successful response (200)

{
  "Code": 200,
  "Status": "OK",
  "Chart": {
    "Id": "chart_1",
    "SecondCategoryAxis": {
      "Title": "New Axis Title",
      "IsVisible": true,
      /* additional axis properties */
    }
  }
}

Error responses

Status Code	Description
400	Bad request – missing or invalid parameters.
401	Unauthorized – invalid or missing JWT token.
404	Not found – the specified file, worksheet, or chart does not exist.
500	Internal server error – unexpected condition on the server.

{
  "Code": 400,
  "Message": "Invalid request payload."
}

Cloud SDK Family

SDKs simplify development by handling low‑level details and allowing you to focus on your business logic. 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:

Notes & Best Practices

The chartIndex parameter is zero‑based; the first chart in a worksheet is index 0.
The API supports both .xlsx and .xls workbook formats.
Include only the properties you need in the axis object; unspecified properties retain their existing values.
Respect rate‑limit guidelines (typically 100 requests per minute per account) to avoid throttling.

Aspose.Cells Cloud API – Update Chart Value Axis (POST /valueaxis)