Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati...
4 installs
Design & media
Excel Chart Report Developer
Try itCreate and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati...
What it does
Create and troubleshoot Excel reporting workbooks with charts, dashboards, conditional formatting, print areas, PDF/image export, openpyxl or Office automati...
The skill document
Excel Chart Report Developer
Use this skill for recurring Excel reports where the workbook is both a data artifact and a presentation artifact. Keep charts, formulas, formatting, print settings, and exports in sync.
Workflow
- Clarify the report target: dashboard workbook, chart pack, PDF export, image export, print-ready report, recurring refresh, or workbook template.
- Separate data, calculations, and presentation:
- Raw or imported data sheets.
- Calculation/helper sheets with formulas and named ranges.
- Output sheets with charts, summaries, conditional formatting, and print areas.
- Choose the automation layer:
- Use
openpyxlfor workbook structure, formulas, styles, charts, tables, print setup, and conditional formatting where supported. - Use Excel desktop automation only when live chart rendering, Power Query refresh, or PDF export fidelity is essential and available.
- Preserve unsupported workbook parts by editing package contents carefully.
- Use
- Design stable ranges. Prefer Excel Tables and named ranges over hard-coded row counts.
- Apply visual formatting after data writes so fills, borders, number formats, widths, and conditional formatting do not drift.
- Validate:
- Formulas point to valid ranges.
- Charts reference current data.
- Print areas, page orientation, margins, headers/footers, and page breaks match the expected export.
- Exports are reviewed for clipping, missing labels, and font substitution.
Common Fix Patterns
- Chart not updating: verify series formulas, named ranges, table expansion, and cached chart data.
- Conditional formatting drift: inspect rule ranges and priority ordering after row insertion.
- Bad PDF export: check print area, scaling, margins, page breaks, and whether a desktop Excel render is required.
- Template overwrites: write values into known input ranges, then preserve output sheets and chart objects.
- Data refresh: log source file timestamps, row counts, and validation totals for each run.
Outputs
Provide:
- A report architecture or repair diagnosis.
- Implementation steps or code for workbook generation/update.
- A validation note covering formulas, charts, formatting, and exports.
Read references/requirement-plan.md only when source evidence from the discovery run is needed.
Related skills
Build and troubleshoot cross-Office automation pipelines that move content between Word, Excel, and PowerPoint using Open XML, VBA, python-docx, openpyxl, py...
4 installs
Build, read, and edit .xlsx workbooks through a CLI with enforced rules for formulas, formatting, and financial-model standards.
24 installs
Diagnose and fix Microsoft Excel XLSX workbook issues involving formulas, named ranges, Power Query refreshes, pivot tables, VBA/macro preservation, workbook...
4 installs
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files into proper spreadsheets.
2 installs
Compose a formula-driven Excel dashboard from CSV input — Dashboard sheet first, with KPI cards, charts, sparklines.
19 installs