Categories

← View All Tools

XLSX Chart Embedder

Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports

Insert charts into Excel workbooks.

  • Reads category/value ranges from workbook sheets
  • Generates bar or pie charts with Canvas
  • Embeds PNG charts into target worksheets
  • Great for lightweight report packs where image-based charts are acceptable

Example Results

1 examples

Embed bar and pie chart images

Generate chart images from worksheet ranges and place them into the workbook

xlsx-chart-embedder-example1.xlsx View File
View input parameters
{ "workbookFile": "/public/samples/xlsx/xlsx-chart-embedder-example1.xlsx", "chartsJson": "[\n {\n \"sheetName\": \"Charts\",\n \"chartType\": \"bar\",\n \"title\": \"Monthly Revenue\",\n \"categoriesRange\": \"Data!A2:A7\",\n \"valuesRange\": \"Data!B2:B7\",\n \"anchorCell\": \"B2\",\n \"widthPx\": 520,\n \"heightPx\": 320\n },\n {\n \"sheetName\": \"Charts\",\n \"chartType\": \"pie\",\n \"title\": \"Orders Share\",\n \"categoriesRange\": \"Data!A2:A7\",\n \"valuesRange\": \"Data!C2:C7\",\n \"anchorCell\": \"B22\",\n \"widthPx\": 520,\n \"heightPx\": 320\n }\n]" }

Click to upload file or drag and drop file here

Maximum file size: 20MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Key Facts

Category
Format Conversion
Input Types
file, textarea
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Chart Embedder is a specialized utility designed to transform your spreadsheet data into visual insights by generating and embedding bar or pie chart images directly into your Excel workbooks.

When to Use

  • •When you need to include static visual summaries in automated Excel report packs.
  • •When you want to display data trends using bar or pie charts without relying on complex native Excel chart objects.
  • •When you need a lightweight, stable way to distribute spreadsheet reports that look consistent across different viewers.

How It Works

  • •Upload your Excel workbook file containing the source data.
  • •Define your chart parameters in the JSON configuration, specifying the sheet name, chart type, and the data ranges for categories and values.
  • •Specify the anchor cell where the generated PNG chart image should be placed within your worksheet.
  • •Process the file to generate and embed the visual charts into the specified locations.

Use Cases

Generating monthly sales performance dashboards for management reports.
Creating visual summaries of survey results or inventory distribution within a spreadsheet.
Standardizing report layouts by embedding consistent chart images across multiple client workbooks.

Examples

1. Monthly Revenue Dashboard

Financial Analyst
Background
The analyst prepares a monthly revenue report and needs to include a visual bar chart comparing performance across different departments.
Problem
Manually creating and pasting charts into Excel is time-consuming and prone to formatting errors.
How to Use
Upload the revenue workbook and provide the JSON configuration to map the department names and revenue figures to a bar chart.
Example Config
[{ "sheetName": "Charts", "chartType": "bar", "title": "Monthly Revenue", "categoriesRange": "Data!A2:A7", "valuesRange": "Data!B2:B7", "anchorCell": "B2", "widthPx": 520, "heightPx": 320 }]
Outcome
A professional bar chart is automatically embedded into the 'Charts' sheet, providing an instant visual overview of revenue.

2. Order Distribution Pie Chart

Operations Manager
Background
The manager needs to visualize the share of orders by region to identify market concentration.
Problem
The raw data is in a table, but stakeholders prefer a visual pie chart for quick decision-making.
How to Use
Configure the tool to read the region and order count columns and embed a pie chart at the bottom of the summary sheet.
Example Config
[{ "sheetName": "Charts", "chartType": "pie", "title": "Orders Share", "categoriesRange": "Data!A2:A7", "valuesRange": "Data!C2:C7", "anchorCell": "B22", "widthPx": 520, "heightPx": 320 }]
Outcome
A clear pie chart is inserted into the workbook, effectively highlighting the distribution of orders by region.

Try with Samples

json, xml, xlsx
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
QR Code Samples
Sample QR code images for testing QR code reading and generation tools
preferred input family json
json
PDF Samples
Generated PDF samples from tools dated 2026-02-01 to 2026-02-10
preferred input family json
json
D3.js Data Visualization Samples
Comprehensive D3.js data visualization examples including charts, maps, animations, and interactive visualizations
preferred input family json
json

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Image Convert Tools
Explore 100 image tools for convert workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 32 xml tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.

FAQ

What chart types are supported?

Currently, the tool supports bar charts and pie charts.

How are the charts added to the file?

The tool generates a PNG image of the chart using Canvas and embeds it directly into the target worksheet at your chosen anchor cell.

Can I choose where the chart appears?

Yes, you can define the exact anchor cell in your JSON configuration to place the chart anywhere in your workbook.

Is the chart data dynamic?

No, the charts are embedded as static images. They will not update automatically if the source data in the spreadsheet changes.

What file formats are accepted?

The tool accepts standard Excel workbook files in .xlsx and .xls formats.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-chart-embedder

Request Parameters

Parameter Name Type Required Description
workbookFile file (Upload required) Yes -
chartsJson textarea Yes -

File type parameters need to be uploaded first via POST /upload/xlsx-chart-embedder to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-chart-embedder": {
      "name": "xlsx-chart-embedder",
      "description": "Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-chart-embedder",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]