Advanced Excel

Advanced Excel Charts API

Chart creation and management

GitHub OpenAPI

Operations 2

GET /me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/charts Microsoft Excel List Worksheet Charts #
POST /me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/charts Microsoft Excel Add Chart to Worksheet #

Documentation

📖
Documentation
https://learn.microsoft.com/en-us/graph/api/resources/excel

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/openapi/advanced-excel-charts-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/json-schema/
📊
JSONStructure
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/json-structure/

Other Resources

🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/json-ld/microsoft-graph-excel-api-context.jsonld
🔗
Vocabulary
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/vocabulary/advanced-excel-vocabulary.yaml
🔗
APIsJSON
https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/apis.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/advanced-excel-charts-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

advanced-excel-charts-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Microsoft Graph Excel Charts API
  description: The Microsoft Graph Excel API provides REST access to Excel workbooks stored in OneDrive, SharePoint, or Teams. Supports reading and writing cell values, executing formulas, managing worksheets, creating charts and tables, and running workbook sessions for transactional batch operations on Excel files.
  version: v1.0
  contact:
    name: Microsoft Graph Support
    url: https://learn.microsoft.com/en-us/graph/overview
  termsOfService: https://www.microsoft.com/en-us/servicesagreement
  license:
    name: Microsoft APIs Terms of Use
    url: https://www.microsoft.com/en-us/servicesagreement
servers:
- url: https://graph.microsoft.com/v1.0
  description: Microsoft Graph API Production
security:
- oauth2: []
tags:
- name: Charts
  description: Chart creation and management
paths:
  /me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/charts:
    get:
      operationId: listCharts
      summary: Microsoft Excel List Worksheet Charts
      description: List all charts in an Excel worksheet.
      tags:
      - Charts
      parameters:
      - name: driveItemId
        in: path
        required: true
        description: OneDrive item ID of the Excel workbook.
        schema:
          type: string
      - name: worksheetId
        in: path
        required: true
        description: Worksheet ID or name.
        schema:
          type: string
      responses:
        '200':
          description: List of charts.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ChartList'
              examples:
                listCharts200Example:
                  summary: Default listCharts 200 response
                  x-microcks-default: true
                  value:
                    value:
                    - id: chart1
                      name: SalesChart
                      chartType: ColumnClustered
                      height: 300
                      width: 500
        '401':
          description: Unauthorized.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                listCharts401Example:
                  summary: Default listCharts 401 response
                  x-microcks-default: true
                  value:
                    error:
                      code: Unauthorized
                      message: Access token is missing or invalid
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    post:
      operationId: addChart
      summary: Microsoft Excel Add Chart to Worksheet
      description: Create a new chart in an Excel worksheet from a specified data range.
      tags:
      - Charts
      parameters:
      - name: driveItemId
        in: path
        required: true
        description: OneDrive item ID of the Excel workbook.
        schema:
          type: string
      - name: worksheetId
        in: path
        required: true
        description: Worksheet ID or name.
        schema:
          type: string
      requestBody:
        required: true
        description: Chart creation parameters.
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ChartInput'
            examples:
              addChartRequestExample:
                summary: Default addChart request
                x-microcks-default: true
                value:
                  type: ColumnClustered
                  sourceData: Sheet1!A1:B10
                  seriesBy: Auto
      responses:
        '201':
          description: Chart created.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Chart'
              examples:
                addChart201Example:
                  summary: Default addChart 201 response
                  x-microcks-default: true
                  value:
                    id: chart2
                    name: Chart 1
                    chartType: ColumnClustered
                    height: 300
                    width: 500
        '401':
          description: Unauthorized.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                addChart401Example:
                  summary: Default addChart 401 response
                  x-microcks-default: true
                  value:
                    error:
                      code: Unauthorized
                      message: Access token is missing or invalid
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  schemas:
    ChartInput:
      type: object
      description: Request to create a chart.
      properties:
        type:
          type: string
          description: Chart type.
          example: ColumnClustered
        sourceData:
          type: string
          description: A1-style range address of the source data.
          example: Sheet1!A1:B10
        seriesBy:
          type: string
          description: How series are plotted.
          enum:
          - Auto
          - Columns
          - Rows
          example: Auto
    Chart:
      type: object
      description: An Excel chart.
      properties:
        id:
          type: string
          description: Chart identifier.
          example: chart1
        name:
          type: string
          description: Chart name.
          example: SalesChart
        chartType:
          type: string
          description: Chart type.
          example: ColumnClustered
        height:
          type: number
          description: Chart height in points.
          example: 300
        width:
          type: number
          description: Chart width in points.
          example: 500
    ErrorResponse:
      type: object
      description: Microsoft Graph API error response.
      properties:
        error:
          type: object
          description: Error details.
          properties:
            code:
              type: string
              description: Error code.
              example: Unauthorized
            message:
              type: string
              description: Error message.
              example: Access token is missing or invalid.
    ChartList:
      type: object
      description: List of charts.
      properties:
        value:
          type: array
          description: Array of charts.
          items:
            $ref: '#/components/schemas/Chart'
  securitySchemes:
    oauth2:
      type: oauth2
      flows:
        authorizationCode:
          authorizationUrl: https://login.microsoftonline.com/common/oauth2/v2.0/authorize
          tokenUrl: https://login.microsoftonline.com/common/oauth2/v2.0/token
          scopes:
            Files.ReadWrite: Read and write user files
            Files.ReadWrite.All: Read and write all files