Agent skill

Mckinsey Charts

by sruthir28 in sruthir28/enterprise-ai-skills

Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint).

MITAuto-check passedDocuments & Office

Install Mckinsey Charts

skills CLI
$ npx skills add sruthir28/enterprise-ai-skills --skill mckinsey-charts -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install sruthir28/enterprise-ai-skills mckinsey-charts --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/sruthir28/enterprise-ai-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/mckinsey-charts .claude/skills/mckinsey-charts && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
mckinsey-charts
GitHub stars
148
Token cost
~999 tokens
SKILL.md length
295 words
Files
3
Skills in repo
14
Repo updated
First seen
Licence
MIT

At a glance

Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint).

  • You need a chart that looks like it came from an EM-reviewed deck
  • SKILL.md covers The Three Charts, Design choices (intentional,…, How to use and Test it, plus 1 more section
  • Runs Python scripts from its folder; calls python3
  • Not from Excel defaults

What it does

Mckinsey Charts is an agent skill from sruthir28/enterprise-ai-skills. Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint). Three workhorse types — bar+callout for TAM/single-number stories, stacked column over time for revenue/usage mix, and waterfall for drivers/bridge analysis. Use when you need a chart that looks like it came from an EM-reviewed deck, not from Excel defaults.

Its SKILL.md is about 1000 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `charts.py` and `test_charts.py`).

It sits in Documents & Office, covering PowerPoint presentations and Excel spreadsheets. It works with Microsoft PowerPoint, python-pptx and Microsoft Excel. The repository describes itself as: Open-source AI skills for enterprise professionals. McKinsey consulting frameworks, PM workflows, and practical tools. Currently for Claude, expanding to other LLMs. The licence is MIT.

When your agent uses it

  • You need a chart that looks like it came from an EM-reviewed deck
  • Not from Excel defaults

Example prompts

  • “/mckinsey-charts”

Requirements

  • Python 3

What it can do on your machine

Read from SKILL.md and the folder at commit ae8fe60. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships script files (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • python3

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Mckinsey Charts loads about 999 tokens when it runs. Until then it costs about 94 tokens; SKILL.md has 295 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~94
When it runs · the whole SKILL.md, loaded when a task matches
~999

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from sruthir28/enterprise-ai-skills at commit ae8fe60, republished under its MIT licence (© sruthir28). 295 words, ~999 tokens.

Download SKILL.mdSave it as .claude/skills/mckinsey-charts/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.
name
mckinsey-charts
description
Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint). Three workhorse types — bar+callout for TAM/single-number stories, stacked column over time for revenue/usage mix, and waterfall for drivers/bridge analysis. Use when you need a chart that looks like it came from an EM-reviewed deck, not from Excel defaults.

McKinsey Charts

Drop-in chart builders for python-pptx. Charts are inserted as native PowerPoint chart objects — your audience can edit the data, change the colors, copy the chart to their own deck. No images, no screenshots.

The Three Charts

TypeWhen to useExample
bar_calloutOne number is the story. TAM, market size, headcount, anything where you want to anchor on a single highlighted bar with a big callout."RTD coffee TAM will hit $42.5B by 2028"
stacked_bar_over_timeComposition over time. Revenue by segment, usage by feature, headcount by function. Shows both total growth and mix shift."Revenue grew 3x, but enterprise segment grew 7x"
waterfallBridging two numbers. Revenue walk, cost walk, headcount changes, any "start → adds → subtracts → end" story."FY24 → FY25 revenue bridge: $80M → $112M"

Design choices (intentional, not configurable)

  • Title is a claim, not a label. "RTD market will hit $42.5B by 2028" beats "Market Size."
  • One highlight color, everything else grey. McKinsey decks don't rainbow. The chart points at one thing.
  • No gridlines, no chart border, no legend unless multi-series. Less ink → more signal.
  • Source line at the bottom in light grey italic. Always include it.
  • Single font (Inter) at consistent sizes. Title 20pt, axis 10pt, source 9pt.

How to use

python
from pptx import Presentation
from pptx.util import Inches
from charts import add_bar_callout, add_stacked_bar_over_time, add_waterfall, new_deck

prs = new_deck()  # 16:9 with title slide layout
slide = prs.slides.add_slide(prs.slide_layouts[6])  # blank

add_bar_callout(
    slide,
    title="RTD coffee TAM will hit $42.5B by 2028",
    categories=["2023", "2024", "2025", "2026", "2027", "2028"],
    values=[28.1, 30.8, 33.6, 36.5, 39.4, 42.5],
    highlight_index=5,        # which bar to highlight (last one here)
    callout="$42.5B\n2028 TAM",
    y_label="USD, billions",
    source="Euromonitor 2025; Mintel; team analysis",
)

prs.save("output.pptx")

Same pattern for the other two:

python
add_stacked_bar_over_time(
    slide,
    title="Enterprise segment now drives 62% of revenue, up from 18% in 2021",
    categories=["2021", "2022", "2023", "2024", "2025"],
    series=[
        ("SMB",        [12, 14, 15, 16, 18]),
        ("Mid-market", [8,  12, 16, 22, 28]),
        ("Enterprise", [4,  10, 22, 38, 74]),
    ],
    highlight_series="Enterprise",
    y_label="Revenue, $M",
    source="Internal financials; FY21–FY25",
)

add_waterfall(
    slide,
    title="FY24 → FY25 revenue bridge: $80M → $112M, with new logos doing the heavy lifting",
    labels=["FY24",  "New logos", "Expansion", "Churn",  "Price",  "FY25"],
    values=[80.0,    24.0,        12.0,        -8.0,     4.0,      112.0],
    kinds=["start",  "pos",       "pos",       "neg",    "pos",    "total"],
    y_label="Revenue, $M",
    source="Internal financials; FY24–FY25",
)

Test it

python3 test_charts.py
open test_output.pptx

The test script generates one slide per chart type with realistic sample data. Open it in PowerPoint or Keynote and right-click any chart → "Edit Data" to confirm it's a native chart, not an image.

When NOT to use this skill

  • You need a distribution (use a histogram or box plot — not a McKinsey staple).
  • You need a scatter / quadrant (the 2x2 / portfolio map is a different skill).
  • You're showing >5 series stacked (split into small multiples instead — one chart can't carry that load).

© sruthir28, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files in mckinsey-charts of sruthir28/enterprise-ai-skills.

  • SKILL.md
  • charts.py
  • test_charts.py

Open the folder on GitHubat commit ae8fe60

Compare with similar skills

Mckinsey Charts next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Mckinsey Charts compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Mckinsey Charts this skillsruthir28/enterprise-ai-skills148—~999Automated safety check: PassMIT
Brand DOCXferdinandobons/brand-docs272—~3.8kAutomated safety check: PassMIT
Brand PPTXferdinandobons/brand-docs272—~3.5kAutomated safety check: PassMIT
Brand XLSXferdinandobons/brand-docs272—~3.3kAutomated safety check: PassMIT
Kb Office RemediationCommunity-Access/accessibility-agents423—~2kAutomated safety check: PassMIT
Office RemediatorCommunity-Access/accessibility-agents423—~1kAutomated safety check: PassMIT

Similar skills

  • Brand DOCX

    ferdinandobons/brand-docs

    Brand-aware Word engine. An agent skill from ferdinandobons/brand-docs.

    272 GitHub stars~3.8k tokensUpdated 3 mo ago
    Documents & OfficeAuto-check passed
  • Brand PPTX

    ferdinandobons/brand-docs

    Brand-aware PowerPoint engine. An agent skill from ferdinandobons/brand-docs.

    272 GitHub stars~3.5k tokensUpdated 3 mo ago
    Documents & OfficeAuto-check passed
  • Brand XLSX

    ferdinandobons/brand-docs

    Brand-aware Excel engine. An agent skill from ferdinandobons/brand-docs.

    272 GitHub stars~3.3k tokensUpdated 3 mo ago
    Documents & OfficeAuto-check passed
  • Kb Office Remediation

    Community-Access/accessibility-agents

    Reference data, not a reviewer. An agent skill from Community-Access/accessibility-agents.

    423 GitHub stars~2k tokensUpdated 17 days ago
    Documents & OfficeAuto-check passed
  • Office Remediator

    Community-Access/accessibility-agents

    Fix .docx, .xlsx and .pptx programmatically via python-docx and friends.

    423 GitHub stars~1k tokensUpdated 17 days ago
    Documents & OfficeAuto-check passed
  • Markitdown

    ImCa0/just-laws

    Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.

    781 GitHub starsUsed in 14 repos~3.2k tokens
    Documents & OfficeAuto-check: notes

More from sruthir28/enterprise-ai-skills

All 14 skills in this repo
  • Storyline Builder

    sruthir28/enterprise-ai-skills

    McKinsey-style storyline framework for building presentation decks.

    148 GitHub starsUsed in 1 repo~1.9k tokens
    Auto-check passed
  • AI Use Case Scorer

    sruthir28/enterprise-ai-skills

    Score and prioritize AI use cases for your own job. An agent skill from sruthir28/enterprise-ai-skills.

    148 GitHub stars~1.5k tokensUpdated 1 mo ago
    Auto-check passed
  • Decision Memo Builder

    sruthir28/enterprise-ai-skills

    Builds a 1-page decision memo (context → options → recommendation → risks → ask) enforcing McKinsey memo DNA — brutal brevity, SCP storyline clarity, decision-forcing output, evidence density.

    148 GitHub stars~1.7k tokensUpdated 1 mo ago
    Auto-check passed
  • Deck Pipeline

    sruthir28/enterprise-ai-skills

    Multi-agent pipeline that builds a polished presentation deck from a single topic.

    148 GitHub stars~2.2k tokensUpdated 1 mo ago
    Auto-check passed
  • Issue Tree Builder

    sruthir28/enterprise-ai-skills

    McKinsey-style issue tree framework for breaking down complex problems into MECE (Mutually Exclusive, Collectively Exhaustive) components.

    148 GitHub stars~1.9k tokensUpdated 1 mo ago
    Auto-check passed
  • Scpr Framework

    sruthir28/enterprise-ai-skills

    SCPR (Situation-Complication-Problem-Recommendation) framework for structured problem solving and executive communication.

    148 GitHub stars~1.2k tokensUpdated 1 mo ago
    Auto-check passed

Questions about Mckinsey Charts

What does Mckinsey Charts do?

Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint). Mckinsey Charts is an agent skill from sruthir28/enterprise-ai-skills. Generate McKinsey-style consulting charts as native python-pptx objects (editable inside PowerPoint).

When should I use Mckinsey Charts?

Mckinsey Charts fits situations like: you need a chart that looks like it came from an EM-reviewed deck; not from Excel defaults.

How do I install Mckinsey Charts in Claude Code?

Run `npx skills add sruthir28/enterprise-ai-skills --skill mckinsey-charts -a claude-code`. Or copy the skill folder (mckinsey-charts in sruthir28/enterprise-ai-skills) into .claude/skills/mckinsey-charts in your project. Claude Code loads it when a task matches its description.

How do I install Mckinsey Charts in Codex?

Run `npx skills add sruthir28/enterprise-ai-skills --skill mckinsey-charts -a codex`. Or copy the skill folder (mckinsey-charts in sruthir28/enterprise-ai-skills) into .agents/skills/mckinsey-charts in your project. Codex loads it when a task matches its description.

Can I use Mckinsey Charts in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add sruthir28/enterprise-ai-skills --skill mckinsey-charts -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/mckinsey-charts, .gemini/skills/mckinsey-charts, .github/skills/mckinsey-charts and .opencode/skills/mckinsey-charts in your project.

What does Mckinsey Charts need to run?

Going by SKILL.md and its folder, Mckinsey Charts needs Python for the scripts in its folder and the command-line tools its instructions call (python3). Our summary lists: Python 3.

Does Mckinsey Charts access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Mckinsey Charts safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Mckinsey Charts use?

Mckinsey Charts is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Mckinsey Charts use?

About 999 tokens (SKILL.md is roughly 4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Mckinsey Charts?

Skills that share tags, products or a category with Mckinsey Charts: Brand DOCX (ferdinandobons/brand-docs, 272 stars), Brand PPTX (ferdinandobons/brand-docs, 272 stars), Brand XLSX (ferdinandobons/brand-docs, 272 stars) and Kb Office Remediation (Community-Access/accessibility-agents, 423 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Mckinsey Charts?

sruthir28 (a GitHub user) maintains it in sruthir28/enterprise-ai-skills, which has 148 GitHub stars. The repository holds 14 skills in this directory. The repository was last updated on September 1, 2026.

Source: sruthir28/enterprise-ai-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.