skills.rest
MichaelYang-lyx
MichaelYang-lyxCOMMUNITY
Explore all skills by this author →
GitHub

excel-bar-chart-visualization

Consolidate multi-sheet Excel data, clean merged cells, and generate bilingual bar charts.

110|3|Updated Feb 26, 2026
Search Tags:#excel#data-visualization#data-cleaning#pivot#multi-sheet
One-click install
npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill excel-bar-chart-visualization-michaelyang-lyx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-bar-chart-visualization
Source: https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-visualization/bar-chart-visualization
Command: npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill excel-bar-chart-visualization-michaelyang-lyx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

读取并汇总来自多工作表的Excel数据，自动处理合并单元格导致的数据不一致，完成数据清洗和交叉分组统计，并生成带总计行的结果表，最后绘制支持中英文字体的美化柱状图，适用于多维度数据汇总与可视化分析。

Core Features & Use Cases

  • 数据合并与清洗：将多个工作表合并为一个数据集并处理合并单元格导致的缺失信息。
  • 交叉分析与汇总：基于分类字段进行跨维度统计，自动生成带总计行的结果表。
  • 可视化输出：绘制美观的柱状图并支持中英字体显示，方便报告与展示。

Quick Start

在一个包含多工作表的 Excel 文件中运行该子技能以完成数据合并、清洗、分组统计并生成带总计行的柱状图。

Frequently Asked Questions about excel-bar-chart-visualization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I consolidate multiple Excel sheets and fix merged cell data inconsistencies?▼

To consolidate multiple Excel sheets and resolve merged cell inconsistencies, this Skill automates data merging and cleaning using pandas and openpyxl, filling missing information caused by merged cells to produce a unified dataset.

Can I generate bar charts with bilingual fonts from cross-tabulated Excel data?▼

Yes, you can generate bar charts with bilingual fonts from cross-tabulated Excel data. This Skill performs cross-tab statistics and uses matplotlib to render publication-ready bar charts supporting both Chinese and English text.

Does this Excel data visualization tool require Python libraries to run?▼

Yes, this Excel data visualization tool requires Python to run. It specifically depends on the pandas, openpyxl, and matplotlib libraries to handle multi-sheet data processing, cross-tab analysis, and chart generation.

How do I add a total row to cross-tabulated Excel pivot statistics?▼

To add a total row to cross-tabulated Excel pivot statistics, this Skill automatically calculates grouped statistics across categorical dimensions and appends a summarized total row to the output table.

What is the best way to automate multi-sheet Excel data cleaning and charting?▼

The best way to automate multi-sheet Excel data cleaning and charting is using this Skill, which orchestrates the entire workflow from handling merged cells and headers to generating cross-tab outputs and publication-ready bar charts.

Related Skills

Explore More Data & Analytics Skills→
aiyinluyaaiyinluya
2

pivot-table-cross-analysis

Clean merged-cell Excel data and generate pandas crosstabs with Seaborn heatmaps.

Community
Intermediate
hmzainjamilhmzainjamil
1

report-generator

Generate formatted reports with charts, tables, and metric summaries from structured data.

Community
Intermediate
legoutlegout
3

table-extractor

Extract structured tabular data from PDF documents using camelot.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

chart-embedded-export

Extract classification distributions, clean text, and compute cross-tabulated statistics for analysis reports.

Community
Advanced