skills.rest
Grong
GrongCOMMUNITY
Explore all skills by this author →
GitHub

officecli-data-dashboard

Builds multi-element Excel dashboards with formula-driven KPI cards, charts, sparklines, and conditional formatting from CSV data.

Updated Jul 10, 2026
Search Tags:#data visualization#charts#dashboard#excel#xlsx#kpi#conditional formatting
One-click install
npx skills add https://github.com/Grong/openhub-client --skill officecli-data-dashboard-grong
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/Grong/openhub-client/tree/main/crates/backend/openhub-app/assets/builtin-skills/officecli-data-dashboard
Command: npx skills add https://github.com/Grong/openhub-client --skill officecli-data-dashboard-grong

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Turning raw CSV or tabular data into a board-ready Excel dashboard requires coordinating KPI formulas, cell-range-linked charts, sparklines, conditional formatting, print setup, and recalculation settings — a composition that is easy to get wrong (stale cached values, blank charts, clipped titles, ### columns). ## Core Features & Use Cases - Dashboard-first composition: Creates a dedicated Dashboard sheet as the active tab on open, with formula-driven KPI cards referencing upstream Data and Summary sheets. - Charts, sparklines, and conditional formatting: Adds cell-range-linked charts with named series and titles, time-series sparklines, and semantic CF rules (data bars, color scales, icon sets, formula rules). - Eight-gate QA delivery pipeline: Verifies KPI formula coverage, chart counts and title widths, series naming, CF presence, activeTab and fullCalcOnLoad settings, placeholder leaks, visual rendering, and cachedValue freshness before delivery. - Use Case: Given a 12-month revenue CSV, produce a single .xlsx where the user lands on a Dashboard sheet showing Total Revenue and other KPIs, a revenue trend line chart, a sparkline, and print-ready one-page output for a board pack. ## Quick Start Ask the AI to build an executive KPI dashboard from your sales CSV file with revenue KPI cards, a trend chart, and print-ready formatting delivered as a single xlsx file.

Frequently Asked Questions about officecli-data-dashboard

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

FAQPage Schema
How do I create an Excel dashboard from a CSV file?▼

Import the CSV into a Data sheet with officecli, add a Dashboard sheet with formula-driven KPI cells referencing the data, then add cell-range-linked charts and sparklines. Finish by setting calc.fullCalcOnLoad and the active tab, then run validate.

How do I add KPI cards and charts to an Excel dashboard?▼

A KPI card is a small gray label cell plus a large bold value cell containing a formula like SUM over the data range. Charts are added with series values pointing at cell ranges such as Sheet1!B2:B13, each with a descriptive title and named series.

Why does my Excel chart render blank in LibreOffice?▼

LibreOffice does not evaluate formulas in hidden columns or hidden sheets at render time, so charts referencing hidden cells render blank. Aggregate into a visible Summary sheet and point chart series at those visible cells instead.

Why does my Excel KPI cell show ### or a stale zero value?▼

The ### symbol means the column is too narrow for the cached value; size width to the widest expected value, typically 22 to 44. Stale zeros happen because fullCalcOnLoad only recalculates at runtime, so re-issue downstream formulas after upstream edits.

When should I not use a dashboard layout for a spreadsheet?▼

Skip the dashboard composition for a single-sheet CSV tracker with formatting, a 3-statement or DCF financial model, or a small weekly report with one chart and under ten rows. Those cases are better served by a plain xlsx workflow or a financial-model skill.

Related Skills

Explore More Data & Analytics Skills→
markus41markus41
12

pandas-cleaning

Clean and standardize messy tabular data into normalized DataFrames and formatted .xlsx files.

Community
Advanced
withmartian-sandboxwithmartian-sandbox

financial-reporting

Prepare financial reports with verified data, variance analysis, and approvals.

Official
Advanced
withmartian-sandbox-darksidewithmartian-sandbox-darkside

financial-reporting

Generate audit-ready financial reports with verified data and variance analysis.

Official
Advanced
inbharataiinbharatai
22

dashboard-builder

Build interactive data dashboards and reports with Streamlit and Dash.

Community
Intermediate