slide-thinkcell

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Slide: think-cell Mastery

幻灯片:think-cell精通

This skill teaches the think-cell-specific techniques that consulting professionals use to produce client-ready charts in PowerPoint. It assumes the user has think-cell installed.
think-cell is a paid Microsoft PowerPoint plugin used by management consulting firms (McKinsey, BCG, Bain, Roland Berger, etc.) for chart production. It runs only on PowerPoint, not WPS — this is one of the reasons consulting firms standardize on Office over WPS.
This skill is tactical: it teaches how to do specific things in think-cell that the official documentation either omits or buries. For chart-design philosophy (when to use a waterfall, axis discipline, chart-junk removal), see
slide-data-viz-principles
.

本技能教授咨询专业人士用于在PowerPoint中制作可交付客户的图表的think-cell专属技巧。前提是用户已安装think-cell。
think-cell是一款付费的Microsoft PowerPoint插件,被管理咨询公司(麦肯锡、BCG、贝恩、罗兰贝格等)用于制作图表。它仅支持PowerPoint,不支持WPS——这也是咨询公司标准化使用Office而非WPS的原因之一。
本技能属于实操导向:教授官方文档未提及或深藏的think-cell具体操作方法。关于图表设计理念(何时使用瀑布图、坐标轴规范、去除图表冗余元素),请参考
slide-data-viz-principles
。

When to Activate

何时激活

Trigger on user requests like:
  • "在 think-cell 里怎么做 [specific chart]"
  • "how do I [specific operation] in think-cell"
  • "think-cell 的瀑布图 / 堆积柱 / 干特图 / 气泡图 / 折线"
  • "make budget-vs-actual chart with think-cell 14"
  • "customize think-cell default colors / style file"
  • "think-cell decoration / 差异线 / 静值线 / CAGR label"
Do not activate when:
  • User wants chart-type philosophy without tool specifics →
    slide-data-viz-principles
  • User uses Excel native, Google Sheets, Tableau, or any non-PPT tool
  • User has not confirmed think-cell access — ask first if ambiguous
  • User wants concept diagrams (no quantitative data) →
    slide-concept-diagrams

在用户提出以下类型的请求时触发:
  • "在 think-cell 里怎么做 [具体图表]"
  • "如何在think-cell中[具体操作]"
  • "think-cell 的瀑布图 / 堆积柱 / 甘特图 / 气泡图 / 折线"
  • "用think-cell 14制作预算与实际对比图"
  • "自定义think-cell默认颜色 / 样式文件"
  • "think-cell装饰 / 差异线 / 静值线 / CAGR标签"
在以下情况请勿激活:
  • 用户需要图表类型选择理念而非工具具体操作 →
    slide-data-viz-principles
  • 用户使用Excel原生功能、Google Sheets、Tableau或任何非PPT工具
  • 用户未确认已安装think-cell——若情况不明请先询问
  • 用户需要概念图(无量化数据)→
    slide-concept-diagrams

Mental Model

核心认知

think-cell automates the non-trivial polish that distinguishes a consulting chart from a generic Excel chart:
Polish elementExcel nativethink-cell
Waterfall (瀑布图)Manually composed from stacked barsNative chart type
Difference markers (差异线)Hand-drawnDrag-snap automatically
CAGR labelsManually computedNative arrow with auto-CAGR
Stacked-with-100% labelsManual text boxesAutomatic
Aligned data labels across chartsPainfulSnaps to grid
Custom color/style per firmTheme hacking
.style
file system
Mekko / MarimekkoNot nativeNative
GanttPainful add-onPolished native
think-cell's value is time saved on polish, not new chart types. A senior consultant uses think-cell to ship a publication-quality chart in 3 minutes that would take 30 in Excel.

think-cell可自动完成高难度的润色工作,这正是咨询级图表与普通Excel图表的区别所在:
润色元素Excel原生功能think-cell
瀑布图由堆积柱手动拼接原生图表类型
差异线手动绘制自动拖拽对齐
CAGR标签手动计算自带箭头,自动计算CAGR
带100%标签的堆积图手动添加文本框自动生成
跨图表数据标签对齐极其麻烦可对齐网格
按公司自定义颜色/样式需修改主题
.style
文件系统
马赛克图(Mekko / Marimekko)无原生支持原生支持
甘特图需难用的插件完善的原生支持
think-cell的价值在于节省润色时间,而非提供新的图表类型。资深咨询师用think-cell只需3分钟就能做出出版级质量的图表,而用Excel需要30分钟。

When think-cell Wins (vs Native PowerPoint Charts)

think-cell的优势场景(对比PowerPoint原生图表)

Reach for think-cell when you need:
  • ✅ Waterfall (瀑布图) — the canonical "value bridge" chart
  • ✅ Difference connectors between bars / stacks (差异线)
  • ✅ CAGR / growth-rate arrows between two data points
  • ✅ Stacked bars/columns with both segment values AND totals labeled
  • ✅ Mekko / Marimekko (variable column widths showing a second dimension)
  • ✅ Gantt charts for project timelines
  • ✅ Bubble charts with consistent label-anchor placement
  • ✅ 100% stacked with automatic per-segment percentages
  • ✅ Value lines / target lines (静值线 / 进值线) overlaid on bars
  • ✅ Consistent corporate/firm style across all charts in a deck
  • ✅ Aligned axes / heights across multiple charts on one page
Skip think-cell when:
  • A simple line chart with default styling suffices
  • The chart is exploratory (you're still deciding); native Excel is faster for iteration
  • You're outside the Office/PowerPoint ecosystem

当你需要以下功能时,优先使用think-cell:
  • ✅ 瀑布图 —— 经典的“价值桥”图表
  • ✅ 柱形/堆积图之间的差异线
  • ✅ 两个数据点之间的CAGR / 增长率箭头
  • ✅ 堆积条形图/柱形图,同时显示分段数值和总计标签
  • ✅ 马赛克图(Mekko / Marimekko)(通过可变柱宽展示第二个维度)
  • ✅ 用于项目时间线的甘特图
  • ✅ 标签锚点位置统一的气泡图
  • ✅ 100%堆积图,自动生成分段百分比
  • ✅ 覆盖在柱形上的值线/目标线(静值线 / 进值线)
  • ✅ 演示文稿中所有图表保持统一的企业/公司风格
  • ✅ 同一页面多个图表的坐标轴/高度对齐
以下情况无需使用think-cell:
  • 只需默认样式的简单折线图
  • 图表处于探索阶段(仍在调整中);Excel原生功能迭代更快
  • 不在Office/PowerPoint生态环境中

Core Charts: How-To Recipes

核心图表:实操教程

Recipe 1: Waterfall (瀑布图)

教程1:瀑布图

When: Decomposition / bridge — start value + ups/downs → end value. Common: profit bridge, revenue walk, headcount roll-forward.
Standard build:
  1. Insert → think-cell → Waterfall
  2. In the data table, the first row is the e-column flag:
    e
    marks bars to be "summed" (totals/subtotals); blank rows are deltas
  3. Type values: positive numbers = up-bars, negative = down-bars; totals get
    e
  4. Adjust connector lines between bars
Pro recipe — two-scenario comparison waterfall (e.g., Plan A vs Plan B over 5 years):
This is a less-known pattern. The official tutorial shows single-scenario; this shows how to put two scenarios on the same waterfall for side-by-side decision visualization.
  1. Insert → Waterfall
  2. Data table layout:
    Year       2024   2025   2026   2027   2028
    Current    10
    Plan A delta       +1     +2     +2     +3
    Plan A total                              [e]
    Plan B delta       +0.5   +1     +2     +4
    Plan B total                              [e]
  3. Color Plan A bars one color, Plan B bars another (lighter shade)
  4. Adjust connector lines — Plan B's connector should originate from the previous Plan B total, not from Plan A's bar
  5. Add absolute value labels at start and end; mark the recommended plan (usually with bold + brand color)
  6. Top-line annotation: "Plan A" / "Plan B" labels positioned above their respective bar groups
Pro recipe — waterfall showing % of starting value as separator:
When you need to show "ABC market each contributed N%, of which EBIT is M%", the trick is to use difference lines (差异线) between segment top and base axis:
  1. Insert reduced-form waterfall (减少式瀑布)
  2. Data: row 1 = total revenue (e.g., 100); row 2 = EBIT portion at top
  3. Adjust connector lines — drop them so segments visually separate
  4. For EBIT-as-% display: use difference line from EBIT top to base axis; double-click the line, change to "差额" mode, format as percentage
  5. For per-segment % of total: select the segment, change label to "absolute value + percentage" mode
This recipe replaces the manual "draw rectangles + text boxes" hack many non-think-cell users default to.
适用场景:分解/桥接——起始值 + 增减项 → 结束值。 常见场景:利润桥、收入走势、人员数量滚动预测。
标准制作步骤:
  1. 插入 → think-cell → 瀑布图
  2. 在数据表中,第一行是e列标志:
    e
    标记需要“求和”的柱形(总计/小计);空行表示增减项
  3. 输入数值:正数 = 上升柱,负数 = 下降柱;总计项标记
    e
  4. 调整柱形之间的连接线
进阶教程——双场景对比瀑布图(例如,5年内的A方案 vs B方案):
这是一个较少人知道的模式。官方教程只展示了单场景;本教程将演示如何将两个场景放在同一张瀑布图中,以便并排对比辅助决策。
  1. 插入 → 瀑布图
  2. 数据表布局:
    Year       2024   2025   2026   2027   2028
    Current    10
    Plan A delta       +1     +2     +2     +3
    Plan A total                              [e]
    Plan B delta       +0.5   +1     +2     +4
    Plan B total                              [e]
  3. 将A方案柱形设为一种颜色,B方案柱形设为另一种颜色(浅色调)
  4. 调整连接线——B方案的连接线应从上一个B方案的总计柱开始,而非A方案的柱形
  5. 在起始和结束位置添加绝对值标签;标记推荐方案(通常用加粗 + 品牌色)
  6. 顶部注释:将“A方案”/“B方案”标签放在各自柱形组的上方
进阶教程——以起始值百分比为分隔的瀑布图:
当你需要展示“ABC市场各部分贡献N%,其中EBIT占M%”时,技巧是在分段顶部和基底轴之间使用差异线:
  1. 插入简化式瀑布图(减少式瀑布)
  2. 数据:第1行 = 总收入(例如100);第2行 = 顶部的EBIT部分
  3. 调整连接线——将其下拉,使分段在视觉上分开
  4. 若要显示EBIT占比:使用从EBIT顶部到基底轴的差异线;双击线条,改为“差额”模式,设置为百分比格式
  5. 若要显示每个分段占总计的百分比:选择分段,将标签改为“绝对值 + 百分比”模式
本教程替代了许多非think-cell用户常用的“手动绘制矩形 + 文本框”的土方法。

Recipe 2: Stacked Columns with Inline Totals + Trends

教程2:带内置总计和趋势的堆积柱形图

When: Year-over-year comparison with composition AND total trend (e.g., "Revenue by product line, with total CAGR shown").
Build:
  1. Insert → think-cell → Stacked column
  2. Enter data: rows = segments, columns = years
  3. Right-click any segment → label → "absolute value" or "percentage"
  4. To show total at top of each stack: right-click → labels → "totals"
  5. To show CAGR between two columns: select first and last column total, right-click → "CAGR arrow"; think-cell calculates and labels automatically
  6. To show per-segment CAGR: select first and last instance of one segment, add CAGR arrow
Critical pro discipline — segment ordering:
Increasing segments go on TOP. Decreasing segments go on BOTTOM.
This is a senior tell that few tutorials cover. When viewers scan a stacked column over time, the visual envelope (the top edge) reads as the dominant trend. If your decreasing segments are on top, the chart visually says "things are flat" when actually the growing segments are hidden underneath. Reorder so growth lives in the visible trend line.
Recipe to fix segment ordering:
  1. Click the segment to move
  2. Drag it to its new vertical position (think-cell allows this directly)
  3. Verify the top-edge trajectory matches the page title's claim
适用场景:同时展示构成和总计趋势的同比对比(例如“按产品线划分的收入,显示总计CAGR”)。
制作步骤:
  1. 插入 → think-cell → 堆积柱形图
  2. 输入数据:行 = 分段,列 = 年份
  3. 右键单击任一分段 → 标签 → “绝对值”或“百分比”
  4. 若要在每个堆积图顶部显示总计:右键单击 → 标签 → “总计”
  5. 若要显示两个柱形之间的CAGR:选择第一个和最后一个柱形的总计,右键单击 → “CAGR箭头”;think-cell会自动计算并添加标签
  6. 若要显示单个分段的CAGR:选择某一分段的第一个和最后一个实例,添加CAGR箭头
重要的专业规范——分段排序:
增长的分段放在顶部,下降的分段放在底部。
这是一个很少有教程提到的资深级细节。当观众查看随时间变化的堆积柱形图时,视觉轮廓(顶部边缘)会被解读为主要趋势。如果下降的分段在顶部,图表会给人“增长平缓”的错觉,而实际上增长的分段被藏在了下面。重新排序,让增长部分体现在可见的趋势线上。
调整分段排序的方法:
  1. 点击要移动的分段
  2. 将其拖动到新的垂直位置(think-cell支持直接拖动)
  3. 确认顶部边缘的走势与页面标题的表述一致

Recipe 3: Combined Monthly + Quarterly Bars (Hierarchical)

教程3:月度+季度组合柱形图(层级式)

When: Monthly data on the same axis as quarterly aggregates (e.g., "12 months of sales + 4 quarter totals on one chart").
Trick: Excel can't do this natively without painful trickery. think-cell technique uses two stacked column charts in exact overlay:
  1. Insert column chart with monthly data (12 columns)
  2. Press Ctrl+D to duplicate, place exactly on top of the original
  3. In duplicate, replace data: J/F/M = Q1 total (650, 650, 650); A/M/J = Q2 total; etc. (each month within the quarter shows the quarter total)
  4. Color the duplicate's bars in a contrasting/lighter shade
  5. Use the bar-width handle (a small dot at the bar edge in think-cell) to widen quarter bars so adjacent ones merge — they form a "quarterly bar" beneath the monthly bars
  6. Move the quarter chart to the bottom layer; align both Y-axes to identical scale
  7. Hide the duplicate's Y-axis (set white); merge the visible frame to one container
  8. The result: monthly bars in foreground, quarterly aggregate bars in background, both on same axis
This recipe is one of the highest-effort-per-payoff techniques in the canon — it solves a problem most people give up on.
适用场景:月度数据与季度汇总数据在同一坐标轴上(例如“一张图中同时展示12个月的销售额 + 4个季度的总计”)。
技巧:Excel原生功能无法轻松实现这一点,需要复杂的操作。think-cell的方法是使用两个完全重叠的堆积柱形图:
  1. 插入包含月度数据的柱形图(12个柱形)
  2. 按Ctrl+D复制,将其精确放在原图的上方
  3. 在复制的图表中替换数据:1月/2月/3月 = 第一季度总计(650, 650, 650);4月/5月/6月 = 第二季度总计;以此类推(季度内的每个月都显示季度总计)
  4. 将复制图表的柱形设为对比色/更浅的色调
  5. 使用柱宽手柄(think-cell中柱形边缘的小点)加宽季度柱形,使相邻的季度柱形合并——它们会在月度柱形下方形成“季度柱”
  6. 将季度图表移到底层;将两个图表的Y轴对齐到相同的刻度
  7. 隐藏复制图表的Y轴(设为白色);将可见的边框合并到一个容器中
  8. 最终效果:月度柱形在前景,季度汇总柱形在背景,两者在同一坐标轴上
本教程是所有技巧中投入产出比最高的之一——它解决了大多数人放弃的难题。

Recipe 4: Stacked Columns with Many Small Categories — "Other" Bucket

教程4:含多个小类别的堆积柱形图——“其他”分类桶

When: Stacked column has 6+ segments, but only the top 3 matter.
Without think-cell: visually chaotic; small segments squeeze together.
think-cell technique:
  1. Hold Shift, click first low-value segment in earliest year, then click last low-value segment in latest year (selects the rectangle of small categories)
  2. Right-click → "Move to other series" (移动到其他系列)
  3. think-cell automatically:
    • Combines those segments into a single "Other" segment
    • Places it consistently across all columns
    • Updates the legend
  4. Reposition "Other" to a less-prominent location (typically top of stack)
  5. The 3 main categories now display clearly
This is the most underused think-cell feature. Most users keep all 8 segments and ship a noisy chart.
适用场景:堆积柱形图有6个以上分段,但只有前3个是重点。
没有think-cell时:视觉混乱,小分段挤在一起。
think-cell技巧:
  1. 按住Shift,点击最早年份的第一个低价值分段,然后点击最晚年份的最后一个低价值分段(选中小类别的矩形区域)
  2. 右键单击 → “移动到其他系列(Move to other series)”
  3. think-cell会自动:
    • 将这些分段合并为一个“其他”分段
    • 在所有柱形中保持位置一致
    • 更新图例
  4. 将“其他”重新定位到不太显眼的位置(通常是堆积图的顶部)
  5. 此时3个主要类别会清晰显示
这是最被低估的think-cell功能。大多数用户会保留全部8个分段,最终做出一张杂乱的图表。

Recipe 5: Trend Line Between Stacked Columns

教程5:堆积柱形图之间的趋势线

When: Showing how individual segments evolve across time, NOT just totals.
Default think-cell behavior: It can draw connecting lines between same-color segments across columns automatically.
Pro polish — filled-area between segments:
The "filled connector" effect (gradients between segments) seen in McKinsey decks is built like this:
  1. Create primary stacked column chart
  2. Duplicate (Ctrl+D), place adjacent
  3. Strip the duplicate down: remove all data labels, axes, gridlines
  4. Recolor the duplicate's segments in white or a very light shade
  5. Move duplicate to fill the gap between original chart segments
  6. Set chart background lines to white; the result is a "filled flow" between time-points
The cleaner alternative: just use think-cell's native segment-connector lines — they're thin curves and read clearly without overdoing it.
适用场景:展示单个分段随时间的变化,而非仅仅是总计。
think-cell默认行为:它可以自动在不同柱形的同色分段之间绘制连接线。
进阶润色——分段之间的填充区域:
麦肯锡演示文稿中常见的“填充连接线”效果(分段之间的渐变)制作方法如下:
  1. 创建主堆积柱形图
  2. 复制(Ctrl+D),放在相邻位置
  3. 精简复制的图表:移除所有数据标签、坐标轴、网格线
  4. 将复制图表的分段重新着色为白色或非常浅的色调
  5. 移动复制的图表,填充原图分段之间的间隙
  6. 将图表背景线设为白色;最终效果是在时间点之间形成“填充流”
更简洁的替代方案:直接使用think-cell原生的分段连接线——它们是细曲线,清晰且不过度花哨。

Recipe 6: Budget vs Actual with Value Lines (think-cell 14+)

教程6:带值线的预算与实际对比图(think-cell 14及以上版本)

When: Showing planned values as floating reference lines on top of actual-value bars.
Pre-version-14 workaround: Convert plan to a line chart, set marker to "long bar," remove line segments, size markers to match bar width. Tedious; few users mastered it.
think-cell 14+ native: Right-click the "plan" series → change marker type → value line (静值线 / 进值线). Each plan-data point becomes a horizontal line floating at its value, scoped to the column it belongs to.
Build:
  1. Stacked or grouped column chart
  2. Add "Plan" series alongside "Actual"
  3. Right-click Plan series → marker type → value line
  4. Adjust line length (drag handle) so it spans the column width
  5. Add label "预算 / Plan" with one line as anchor
适用场景:将计划值显示为浮动参考线,叠加在实际值柱形上方。
14版本之前的替代方案:将计划数据转换为折线图,将标记设为“长条形”,移除折线段,调整标记大小以匹配柱宽。操作繁琐,很少有用户掌握。
think-cell 14及以上版本原生功能:右键单击“计划”系列 → 更改标记类型 → 值线(静值线 / 进值线)。每个计划数据点都会变成一条浮动在对应数值上的水平线,仅属于其所在的柱形。
制作步骤:
  1. 堆积或簇状柱形图
  2. 在“实际”系列旁添加“计划”系列
  3. 右键单击“计划”系列 → 标记类型 → 值线
  4. 调整线条长度(拖动手柄),使其覆盖整个柱宽
  5. 添加“预算 / Plan”标签,以线条为锚点

Recipe 7: Showing Variance % as a Sub-Row (think-cell 14+)

教程7:以子行显示差异百分比(think-cell 14及以上版本)

When: You want a column chart at top, with a row beneath showing period-by-period variance (Plan vs Actual %).
Pre-14 workaround: Manually placed think-cell mini-table beneath the chart, aligned by hand.
think-cell 14+ native — "Enable data table for chart":
  1. think-cell options → Enable data table for chart (must be turned on)
  2. Add a row to the chart's underlying data table containing the variance %
  3. Right-click the variance row → "Move below chart" (移入到表格下方)
  4. think-cell renders this row as a labeled strip directly under the bars, perfectly aligned column-by-column
  5. Style: format as percentage; color positive/negative differently if useful
This eliminates the historical pain of aligning a mini-table to a chart.
适用场景:上方是柱形图,下方有一行显示每个周期的差异(计划 vs 实际百分比)。
14版本之前的替代方案:手动将think-cell迷你表格放在图表下方,手动对齐。
think-cell 14及以上版本原生功能——“为图表启用数据表”:
  1. think-cell选项 → 为图表启用数据表(必须先开启)
  2. 在图表的底层数据表中添加一行,包含差异百分比数据
  3. 右键单击差异行 → “移入到表格下方(Move below chart)”
  4. think-cell会将这行渲染为带标签的条带,直接显示在柱形下方,与每个柱形完美对齐
  5. 样式:设置为百分比格式;如有需要,可给正/负值设置不同颜色
这解决了长期以来迷你表格与图表对齐的痛点。

Recipe 8: Line Chart with Logarithmic / Indexed Axis

教程8:带对数/索引坐标轴的折线图

When: Comparing series where absolute values differ by orders of magnitude (e.g., one series ranges 100-200, another 1-10).
Pro technique — index-to-100 (指数化):
  1. Pre-process data in Excel: divide each series by its first value × 100
  2. Now all series start at 100; differences are %-relative
  3. Insert think-cell line chart
  4. Y-axis label: "Index, base year = 100"
This is better than dual-axis. Dual-axis creates false correlation illusions. Indexing puts both series on a common, interpretable scale.
think-cell's value here: clean axis formatting + the discipline of labeling the index baseline clearly.
适用场景:比较绝对值相差数个数量级的系列(例如,一个系列范围是100-200,另一个是1-10)。
专业技巧——指数化(以100为基准):
  1. 在Excel中预处理数据:将每个系列除以其第一个值再乘以100
  2. 此时所有系列都从100开始;差异为相对百分比
  3. 插入think-cell折线图
  4. Y轴标签:“指数,基准年 = 100”
这优于双轴。双轴会造成虚假的相关性错觉。指数化将两个系列放在统一的、可解读的刻度上。
think-cell在这里的价值:简洁的坐标轴格式 + 清晰标记指数基线的规范。

Recipe 9: Bubble Chart Variants

教程9:气泡图变体

When: 3-variable visualization (x, y, size).
think-cell default bubble chart is straightforward. The pro variants:
  • Bubble chart with 4th variable via color — assign a categorical color per bubble
  • Variant: 气泡图变形 (deformed bubbles) — non-circular bubbles representing geographic shapes or qualitative categories. think-cell supports custom shapes for bubble markers; replace the default circle with a custom shape (small SVG or PowerPoint shape)

适用场景:三变量可视化(x轴、y轴、气泡大小)。
think-cell默认气泡图非常简单。进阶变体包括:
  • 通过颜色展示第四个变量的气泡图 —— 为每个气泡分配一个分类颜色
  • 变体:变形气泡图(deformed bubbles) —— 用非圆形气泡表示地理形状或定性类别。think-cell支持气泡标记的自定义形状;将默认圆形替换为自定义形状(小型SVG或PowerPoint形状)

Customizing think-cell Style: Your Personal
.style
File

自定义think-cell样式:你的专属
.style
文件

Every consulting firm using think-cell has a custom
.style
file that defines:
  • Default colors (primary, accents, segment palette)
  • Default border weights
  • Default fonts
  • Per-chart-type style overrides
Killer move: build your own
.style
file
.
每家使用think-cell的咨询公司都有自定义的
.style
文件,定义了:
  • 默认颜色(主色、强调色、分段调色板)
  • 默认边框粗细
  • 默认字体
  • 各图表类型的样式覆盖规则
杀手锏:创建你自己的
.style
文件
。

How to Customize

如何自定义

  1. Open the Insert → think-cell → Load Style File dropdown — note that default is "Default" (literally "默认格式")
  2. Locate the style files folder (typically
    C:\Program Files\think-cell\styles\
    or under
    %APPDATA%\think-cell\
    )
  3. Open the default
    .style
    file in a text editor
  4. Reference: think-cell home page → Resources → Style File Format documentation lists every key
  5. Edit colors using the format
    #RRGGBB
    or theme-color references
  6. Save as
    myname.style
    in the same folder
  7. Back in PowerPoint: think-cell → Load Style File → myname.style
  1. 打开插入 → think-cell → 加载样式文件下拉菜单——注意默认选项是“Default”(字面意思是“默认格式”)
  2. 找到样式文件文件夹(通常是
    C:\Program Files\think-cell\styles\
    或
    %APPDATA%\think-cell\
    目录下)
  3. 在文本编辑器中打开默认的
    .style
    文件
  4. 参考资料:think-cell官网 → 资源 → 样式文件格式文档列出了所有配置项
  5. 使用
    #RRGGBB
    格式或主题颜色引用编辑颜色
  6. 在同一文件夹中另存为
    myname.style
  7. 回到PowerPoint:think-cell → 加载样式文件 → myname.style

What to Customize First

优先自定义哪些内容

Minimum viable custom style:
default theme color 1: <your brand primary>
default theme color 2: <accent>
border default: 0.25pt gray
label font: <your firm's font, e.g., Arial Narrow>
chart title font: <same family, larger>
gantt bar default: <consistent neutral color>
最小可用自定义样式:
default theme color 1: <your brand primary>
default theme color 2: <accent>
border default: 0.25pt gray
label font: <your firm's font, e.g., Arial Narrow>
chart title font: <same family, larger>
gantt bar default: <consistent neutral color>

Critical Distribution Note

重要的分发注意事项

Once your
.style
is loaded into a PPT and you save the file as a
.potx
template, the style is embedded in the file. Recipients without your
.style
file still see the styled charts correctly — but they cannot extract your
.style
to reuse elsewhere.
This means:
  • You can ship styled decks safely; recipients see your style
  • You don't have to share the
    .style
    file unless you want them to apply it elsewhere
  • Many consulting firms treat their
    .style
    as IP — never share externally

一旦你的
.style
文件加载到PPT中,并且你将文件另存为
.potx
模板,样式就会嵌入到文件中。没有你的
.style
文件的收件人仍然可以正确查看带样式的图表——但他们无法提取你的
.style
文件在其他地方复用。
这意味着:
  • 你可以安全地发送带样式的演示文稿;收件人能看到你的样式
  • 你不必分享
    .style
    文件,除非你希望他们在其他地方应用该样式
  • 许多咨询公司将其
    .style
    文件视为IP——切勿对外分享

Cross-Chart Polish Discipline

跨图表润色规范

Beyond individual recipes, think-cell rewards consistent discipline:
除了单个教程的技巧,保持一致的规范能让think-cell发挥更大价值:

Equal Heights / Aligned Axes

等高 / 坐标轴对齐

When two charts sit side-by-side on a page, their plot areas should have identical heights and y-axis ranges (when commensurable). think-cell auto-aligns when you select both and use "align" — use it.
当页面上有两个并排的图表时,它们的绘图区高度和Y轴范围应该相同(如果可比的话)。选中两个图表后使用“对齐”功能,think-cell会自动对齐——请善用该功能。

Label Anchor Consistency

标签锚点一致性

think-cell labels snap to standard anchor positions (left of bar, top of column, inside-end, etc.). Pick one anchor convention per chart type across the entire deck. Mixing anchors signals amateur.
think-cell的标签会吸附到标准锚点位置(条形左侧、柱形顶部、内部末端等)。在整个演示文稿中,每种图表类型选择一种锚点规范。混用锚点会显得不专业。

Color Discipline

颜色规范

Use ≤ 4 colors per chart, ≤ 3 colors per stack-segment series. Reserve brand color for the segment / line that the page title is talking about; neutral gray for everything else.
每张图表使用不超过4种颜色,每个堆积分段系列不超过3种颜色。将品牌色留给页面标题所强调的分段/线条;其他所有内容用中性灰色。

Decoration Density

装饰密度

Difference markers, CAGR arrows, callout boxes — use at most 2 per chart. More than that = "I'm trying to say too many things." Make a second chart.

差异标记、CAGR箭头、标注框——每张图表最多使用2个。超过2个就等于“我想表达的内容太多了”,不如做第二张图表。

Anti-Patterns (DO NOT)

反模式(请勿这样做)

1. Using think-cell as a generic chart tool

1. 把think-cell当作通用图表工具使用

Inserting a think-cell chart when a native PowerPoint chart suffices — you'll over-configure and waste time. think-cell shines on the polish layer of complex charts; it's overkill for a simple line chart.
当PowerPoint原生图表就能满足需求时,反而插入think-cell图表——你会在配置上浪费过多时间。think-cell的优势在于复杂图表的润色层;对于简单折线图来说大材小用。

2. Showing everything think-cell can show

2. 堆砌think-cell的所有功能

A think-cell waterfall with CAGR + difference markers + value lines + 8 segment colors + sub-table = visual chaos. Pick the 1–2 things the title needs. Strip the rest.
一张think-cell瀑布图同时包含CAGR + 差异标记 + 值线 + 8种分段颜色 + 子表格 = 视觉混乱。选择标题需要的1-2个元素即可,其余都删掉。

3. Default style on client-facing decks

3. 面向客户的演示文稿使用默认样式

The default think-cell style screams "I just installed this." Always load a custom or firm-specific style for client work. Even a 5-minute custom style file beats default.
默认的think-cell样式会给人“我刚装了这个软件”的感觉。面向客户的工作一定要加载自定义或公司专属的样式。哪怕是花5分钟做的自定义样式文件也比默认的好。

4. Truncating / breaking axes for fit

4. 为了适配截断/断开坐标轴

When stacked column has both 1B and 2M values, some users compress the high values with axis breaks (折断). think-cell can do this, but the author warns against it: it distorts proportional perception. Better approach: use the "Move to Other series" trick (Recipe 4) or split into two charts.
当堆积柱形图同时有10亿和200万的数值时,有些用户会用坐标轴截断来压缩高数值。think-cell支持这个功能,但作者警告不要这么做:它会扭曲比例感知。更好的方法是使用“移动到其他系列”技巧(教程4)或拆分为两张图表。

5. Ignoring segment-order discipline

5. 忽视分段排序规范

Putting decreasing segments at the top of stacked columns (covered in Recipe 2). Always: growth on top, decline on bottom — the top edge is what the audience reads.
将下降的分段放在堆积柱形图的顶部(教程2中已提及)。永远记住:增长在上,下降在下——观众看到的是顶部边缘的走势。

6. Using Mekko when a 2D matrix would do

6. 能用二维矩阵时却用马赛克图

Mekko (variable-width stacked columns) is information-dense and beautiful, but most readers can't decode the 2D area mapping at a glance. If the 30-second test fails, fall back to a quadrant matrix or two separate charts.
马赛克图(可变宽度堆积柱形图)信息密度高且美观,但大多数读者无法一眼看懂二维面积映射。如果30秒内看不懂,就改用象限矩阵或两张独立的图表。

7. Ignoring
.style
files for routine work

7. 日常工作中忽视
.style
文件

If you make charts daily, time spent on a
.style
pays back within days. Skipping this is the most common reason individual consultants' charts look amateur compared to firm-shop output.

如果你每天都要做图表,花在
.style
文件上的时间几天就能回本。个体咨询师的图表看起来不如公司专业团队出品的,最常见的原因就是忽略了这一点。

Quick Self-Check Before Shipping a think-cell Chart

交付think-cell图表前快速自查清单

  • Chart type matches the argument (waterfall for bridges, stacked for composition+time, etc.)
  • Stack segments ordered: growth on top, decline on bottom
  • No more than ~5 visible segments (use "Move to Other" if needed)
  • Custom
    .style
    loaded (not default)
  • Decoration count ≤ 2 (difference markers / CAGR arrows / callouts)
  • Plot area heights aligned across multi-chart pages
  • Label anchors consistent across the deck
  • No axis breaks distorting proportions
  • Brand color reserved for the page-title's emphasis target
  • Page title and chart title don't overlap with chart's own labels

  • 图表类型与论点匹配(桥接用瀑布图,构成+时间用堆积图等)
  • 堆积分段排序正确:增长在上,下降在下
  • 可见分段不超过约5个(如有需要使用“移动到其他系列”)
  • 已加载自定义
    .style
    (非默认样式)
  • 装饰元素数量≤2(差异标记 / CAGR箭头 / 标注框)
  • 多图表页面的绘图区高度对齐
  • 整个演示文稿的标签锚点一致
  • 没有坐标轴截断扭曲比例
  • 品牌色留给页面标题强调的目标
  • 页面标题和图表标题不与图表自身的标签重叠

Quick Reference: Vocabulary

快速参考:词汇表

中文EnglishWhat it is
瀑布图WaterfallBridge chart for value walks
堆积柱状图Stacked columnComposition + trend
干特图GanttProject timeline
Mekko / 马赛克图MarimekkoVariable-width stacked column
差异线Difference connectorMarks delta between two bars/segments
CAGR 箭头CAGR arrowAuto-computed growth rate label
静值线 / 进值线Value lineHorizontal floating reference line (think-cell 14+)
移动到其他系列Move to other series"Other" bucket trick for small segments
表格下数据Below-chart data rowVariance %, sub-table aligned to chart (think-cell 14+)
.style 文件Style filethink-cell's customization mechanism
加载样式文件Load style fileApply a .style to current PPT
指数化Index-to-100Pre-processing trick for cross-magnitude line charts
中文English说明
瀑布图Waterfall用于价值走势的桥接图表
堆积柱状图Stacked column展示构成 + 趋势
甘特图Gantt项目时间线
Mekko / 马赛克图Marimekko可变宽度堆积柱形图
差异线Difference connector标记两个柱形/分段之间的差值
CAGR 箭头CAGR arrow自动计算的增长率标签
静值线 / 进值线Value line水平浮动参考线(think-cell 14及以上版本支持)
移动到其他系列Move to other series处理小分段的“其他”分类桶技巧
表格下数据Below-chart data row差异百分比,与图表对齐的子表格(think-cell 14及以上版本支持)
.style 文件Style filethink-cell的自定义机制
加载样式文件Load style file为当前PPT应用.style文件
指数化Index-to-100处理跨数量级折线图的预处理技巧