skills.rest
aiyinluya
aiyinluyaCOMMUNITY
Explore all skills by this author →
GitHub

pie-chart-data-analysis

Analyze multi-sheet Excel or CSV files and export an Excel report with a pie chart.

2|Updated May 19, 2026
Search Tags:#data visualization#aggregation#data analysis#excel#csv#pie chart#report export
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill pie-chart-data-analysis-aiyinluya
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pie-chart-data-analysis
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-data-visualization/pie-chart-visualization
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill pie-chart-data-analysis-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the problem of manually summarizing multi-sheet Excel or CSV data by automatically finding category and value fields, computing totals and percentages, and producing a downloadable analysis report with a styled pie chart.

Core Features & Use Cases

  • Multi-sheet ingestion: Reads all sheets from an .xlsx file (or a single dataset from .csv) and determines processing strategy using total row count.
  • Auto field detection & cleaning: Identifies likely numeric “value” columns and categorical “group” columns, then cleans and converts types (including forward-filling merged Excel cells).
  • Aggregation with clear outputs: Groups by category, calculates percentage share, sorts by magnitude, and appends a total row for easy interpretation.
  • Visualization + report export: Generates a highlighted (exploded) pie chart and embeds it into a downloadable Excel report.

Quick Start

Use the pie-chart-data-analysis skill on your uploaded .xlsx or .csv file to produce a downloaded Excel report containing a category share pie chart and summary statistics.

Frequently Asked Questions about pie-chart-data-analysis

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

FAQPage Schema
How do I generate pie charts from Excel data automatically?▼

To generate pie charts from Excel data, this skill auto-detects category and numeric value columns, aggregates records to calculate category share percentages, and renders an exploded pie chart embedded in a downloadable Excel report.

Can I analyze multi-sheet Excel files and calculate percentage shares?▼

Yes, you can analyze multi-sheet Excel files by ingesting all sheets, grouping records by categorical labels, summing numeric values, and computing percentage shares to produce a sorted summary table with a total row.

How does automatic field detection work when creating pie charts from CSV files?▼

Automatic field detection works by identifying likely categorical group columns and numeric value columns in your CSV, cleaning data types, forward-filling merged cells, and grouping data to calculate category share percentages for pie chart rendering.

What is the best way to summarize categorical data and export an Excel report with a pie chart?▼

The best way to summarize categorical data is using group-by aggregation to calculate totals and percentage shares, then exporting a styled Excel report with an embedded exploded pie chart and summary statistics.

Does this data aggregation tool handle merged cells and messy numeric conversion in CSV or Excel datasets?▼

Yes, this data aggregation tool handles merged cells by forward-filling values and cleans messy data by automatically converting types to ensure accurate numeric aggregation for category share calculations.

Are there limitations when processing flat CSV tables versus multi-sheet Excel workbooks for pie chart visualization?▼

When processing flat CSV tables, the tool reads a single dataset, whereas multi-sheet Excel workbooks require total row count detection to determine the processing strategy for generating category share pie charts.

Related Skills

Explore More Data & Analytics Skills→
MichaelYang-lyxMichaelYang-lyx
110

numeric-format-normalization

Normalize numeric columns in Excel workbooks and verify totals against a Summary sheet.

Community
Intermediate
aiyinluyaaiyinluya
2

stacked-chart-visualization

Converts percentage strings to numeric shares and plots validated stacked bar charts as PNGs.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

category-statistics

Extract category distributions and generate bar, pie, and horizontal charts from datasets.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

pie-chart-data-analysis

Analyze multi-sheet Excel and CSV data and generate a downloadable pie-chart report.

Community
Intermediate