officecli-data-dashboard

Build a 12-month revenue dashboard with four formula-driven KPI cards, a line chart linked to cell ranges, and a sparkline, ensuring the Dashboard sheet opens as the active tab on load
Create an executive summary layout with a KPI strip, stacked charts, conditional formatting rules on numeric columns, and print-ready delivery scoped to the Dashboard sheet

Single .xlsx file with a Dashboard sheet, KPI cards, charts, sparklines, and conditional formatting

Not intended for a single-sheet CSV-with-formatting tracker with no Dashboard sheet or KPI cards
Not intended for 3-statement, DCF, or LBO financial models
Not intended for weekly status reports with one summary and one chart over fewer than 10 rows
Inline chart data is for demos only; cell-range references are required for delivered dashboards
LibreOffice does not evaluate formulas in hidden columns or sheets at render time
series1.xValues is unsupported for scatter charts
Verify the KPI formula count matches the planned KPI count using query with a has(formula) selector on the Dashboard sheet
Confirm the Dashboard sheet active tab index by querying the sheet list before setting activeTab

AI 搜索