Financial Charts

by pedro-mello30

artdata

Create professional financial charts and visualizations using Python/Plotly. Use when building Sankey diagrams (income statement flows, revenue breakdowns), waterfall charts (profit walkdowns, revenue bridges), bar charts (margin comparisons, segment breakdowns), or line charts (trend analysis, multi-company comparisons). Triggers on chart creation requests, financial visualization needs, or data presentation tasks.

Skill Details

Repository Files

10 files in this skill directory


name: financial-charts description: Create professional financial charts and visualizations using Python/Plotly. Use when building Sankey diagrams (income statement flows, revenue breakdowns), waterfall charts (profit walkdowns, revenue bridges), bar charts (margin comparisons, segment breakdowns), or line charts (trend analysis, multi-company comparisons). Triggers on chart creation requests, financial visualization needs, or data presentation tasks.

Financial Charts

Create publication-quality financial visualizations: Sankey flows, waterfalls, bar charts, and line charts.

Quick Reference

Need Function Script
Income statement flow create_income_statement_sankey() sankey_chart.py
Profit walkdown create_profit_walkdown() waterfall_chart.py
Revenue bridge create_revenue_bridge() waterfall_chart.py
Margin comparison create_margin_comparison_chart() bar_chart.py
Revenue segments create_revenue_segment_chart() bar_chart.py
Trend analysis create_trend_chart() line_chart.py
Multi-line comparison create_multi_line_chart() line_chart.py

Workflow

  1. Identify chart type from Quick Reference
  2. Prepare data in required format
  3. Select theme (default, corporate, dark, apple, tech, financial, minimal)
  4. Run script with parameters
  5. Output as .png, .html, or .pdf

Example: Income Statement Sankey

Creates a flow diagram like Apple's FY22 visualization (see assets/chart-example.png):

from scripts.sankey_chart import create_income_statement_sankey

create_income_statement_sankey(
    revenue_sources={
        "iPhone": 205.5e9,
        "Mac": 40.2e9,
        "iPad": 29.3e9,
        "Wearables": 41.2e9,
        "Services": 78.1e9,
    },
    cost_of_revenue=223.6e9,
    operating_expenses={"R&D": 26.2e9, "SG&A": 25.1e9},
    other_expenses={"Tax": 19.3e9, "Other": 0.3e9},
    company_name="Apple",
    fiscal_period="FY22",
    theme="apple",
    output_path="apple_income_flow.png",
)

Example: Waterfall Chart

from scripts.waterfall_chart import create_profit_walkdown

create_profit_walkdown(
    revenue=100e6,
    cost_of_goods_sold=60e6,
    operating_expenses={"R&D": 10e6, "SG&A": 15e6},
    other_items={"Tax": -3e6},
    title="Q4 Profit Walkdown",
    output_path="walkdown.png",
)

Themes

All scripts accept theme parameter:

  • default - Professional blue/green
  • corporate - Traditional business
  • dark - Dark mode dashboards
  • apple - Apple-style clean
  • tech - Modern tech
  • financial - Banking style
  • minimal - Grayscale with accents

Dependencies

pip install plotly kaleido

Extended Reference

For detailed API, all parameters, and advanced customization, see references/chart-guide.md.

Related Skills

Xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

Data Storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

data

Team Composition Analysis

This skill should be used when the user asks to "plan team structure", "determine hiring needs", "design org chart", "calculate compensation", "plan equity allocation", or requests organizational design and headcount planning for a startup.

artdesign

Startup Financial Modeling

This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or requests 3-5 year financial planning for a startup.

art

Kpi Dashboard Design

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

designdata

Dbt Transformation Patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

testingdocumenttool

Startup Metrics Framework

This skill should be used when the user asks about "key startup metrics", "SaaS metrics", "CAC and LTV", "unit economics", "burn multiple", "rule of 40", "marketplace metrics", or requests guidance on tracking and optimizing business performance metrics.

art

Skill Information

Category:Creative
Last Updated:1/7/2026