📊 Excel & Spreadsheets Prompts
Formulas, reports, pivot tables, charts, VBA macros
← All Categories
1 prompts
in Charts & Visualization
Professional Dashboard with Charts
Create instructions for building a professional Excel dashboard with these charts: 1) Revenue trend line chart (monthly, 12 months), 2) Sales by region donut chart, 3) Top 5 products horizontal bar chart, 4) KPI scorecard with conditional formatting (green/yellow/red), 5) Sparklines in cells for quick trend visualization. Include specific formatting tips: remove gridlines, use a consistent color palette, align charts to a grid layout.
💡 Use named ranges for chart data so they auto-update when new data is added.