slide-thinkcell
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseSlide: 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-principlesWhen 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 element | Excel native | think-cell |
|---|---|---|
| Waterfall (瀑布图) | Manually composed from stacked bars | Native chart type |
| Difference markers (差异线) | Hand-drawn | Drag-snap automatically |
| CAGR labels | Manually computed | Native arrow with auto-CAGR |
| Stacked-with-100% labels | Manual text boxes | Automatic |
| Aligned data labels across charts | Painful | Snaps to grid |
| Custom color/style per firm | Theme hacking | |
| Mekko / Marimekko | Not native | Native |
| Gantt | Painful add-on | Polished 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%标签的堆积图 | 手动添加文本框 | 自动生成 |
| 跨图表数据标签对齐 | 极其麻烦 | 可对齐网格 |
| 按公司自定义颜色/样式 | 需修改主题 | |
| 马赛克图(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:
- Insert → think-cell → Waterfall
- In the data table, the first row is the e-column flag: marks bars to be "summed" (totals/subtotals); blank rows are deltas
e - Type values: positive numbers = up-bars, negative = down-bars; totals get
e - 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.
- Insert → Waterfall
- 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] - Color Plan A bars one color, Plan B bars another (lighter shade)
- Adjust connector lines — Plan B's connector should originate from the previous Plan B total, not from Plan A's bar
- Add absolute value labels at start and end; mark the recommended plan (usually with bold + brand color)
- 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:
- Insert reduced-form waterfall (减少式瀑布)
- Data: row 1 = total revenue (e.g., 100); row 2 = EBIT portion at top
- Adjust connector lines — drop them so segments visually separate
- For EBIT-as-% display: use difference line from EBIT top to base axis; double-click the line, change to "差额" mode, format as percentage
- 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.
适用场景:分解/桥接——起始值 + 增减项 → 结束值。
常见场景:利润桥、收入走势、人员数量滚动预测。
标准制作步骤:
- 插入 → think-cell → 瀑布图
- 在数据表中,第一行是e列标志:标记需要“求和”的柱形(总计/小计);空行表示增减项
e - 输入数值:正数 = 上升柱,负数 = 下降柱;总计项标记
e - 调整柱形之间的连接线
进阶教程——双场景对比瀑布图(例如,5年内的A方案 vs B方案):
这是一个较少人知道的模式。官方教程只展示了单场景;本教程将演示如何将两个场景放在同一张瀑布图中,以便并排对比辅助决策。
- 插入 → 瀑布图
- 数据表布局:
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] - 将A方案柱形设为一种颜色,B方案柱形设为另一种颜色(浅色调)
- 调整连接线——B方案的连接线应从上一个B方案的总计柱开始,而非A方案的柱形
- 在起始和结束位置添加绝对值标签;标记推荐方案(通常用加粗 + 品牌色)
- 顶部注释:将“A方案”/“B方案”标签放在各自柱形组的上方
进阶教程——以起始值百分比为分隔的瀑布图:
当你需要展示“ABC市场各部分贡献N%,其中EBIT占M%”时,技巧是在分段顶部和基底轴之间使用差异线:
- 插入简化式瀑布图(减少式瀑布)
- 数据:第1行 = 总收入(例如100);第2行 = 顶部的EBIT部分
- 调整连接线——将其下拉,使分段在视觉上分开
- 若要显示EBIT占比:使用从EBIT顶部到基底轴的差异线;双击线条,改为“差额”模式,设置为百分比格式
- 若要显示每个分段占总计的百分比:选择分段,将标签改为“绝对值 + 百分比”模式
本教程替代了许多非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:
- Insert → think-cell → Stacked column
- Enter data: rows = segments, columns = years
- Right-click any segment → label → "absolute value" or "percentage"
- To show total at top of each stack: right-click → labels → "totals"
- To show CAGR between two columns: select first and last column total, right-click → "CAGR arrow"; think-cell calculates and labels automatically
- 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:
- Click the segment to move
- Drag it to its new vertical position (think-cell allows this directly)
- Verify the top-edge trajectory matches the page title's claim
适用场景:同时展示构成和总计趋势的同比对比(例如“按产品线划分的收入,显示总计CAGR”)。
制作步骤:
- 插入 → think-cell → 堆积柱形图
- 输入数据:行 = 分段,列 = 年份
- 右键单击任一分段 → 标签 → “绝对值”或“百分比”
- 若要在每个堆积图顶部显示总计:右键单击 → 标签 → “总计”
- 若要显示两个柱形之间的CAGR:选择第一个和最后一个柱形的总计,右键单击 → “CAGR箭头”;think-cell会自动计算并添加标签
- 若要显示单个分段的CAGR:选择某一分段的第一个和最后一个实例,添加CAGR箭头
重要的专业规范——分段排序:
增长的分段放在顶部,下降的分段放在底部。
这是一个很少有教程提到的资深级细节。当观众查看随时间变化的堆积柱形图时,视觉轮廓(顶部边缘)会被解读为主要趋势。如果下降的分段在顶部,图表会给人“增长平缓”的错觉,而实际上增长的分段被藏在了下面。重新排序,让增长部分体现在可见的趋势线上。
调整分段排序的方法:
- 点击要移动的分段
- 将其拖动到新的垂直位置(think-cell支持直接拖动)
- 确认顶部边缘的走势与页面标题的表述一致
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:
- Insert column chart with monthly data (12 columns)
- Press Ctrl+D to duplicate, place exactly on top of the original
- 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)
- Color the duplicate's bars in a contrasting/lighter shade
- 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
- Move the quarter chart to the bottom layer; align both Y-axes to identical scale
- Hide the duplicate's Y-axis (set white); merge the visible frame to one container
- 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的方法是使用两个完全重叠的堆积柱形图:
- 插入包含月度数据的柱形图(12个柱形)
- 按Ctrl+D复制,将其精确放在原图的上方
- 在复制的图表中替换数据:1月/2月/3月 = 第一季度总计(650, 650, 650);4月/5月/6月 = 第二季度总计;以此类推(季度内的每个月都显示季度总计)
- 将复制图表的柱形设为对比色/更浅的色调
- 使用柱宽手柄(think-cell中柱形边缘的小点)加宽季度柱形,使相邻的季度柱形合并——它们会在月度柱形下方形成“季度柱”
- 将季度图表移到底层;将两个图表的Y轴对齐到相同的刻度
- 隐藏复制图表的Y轴(设为白色);将可见的边框合并到一个容器中
- 最终效果:月度柱形在前景,季度汇总柱形在背景,两者在同一坐标轴上
本教程是所有技巧中投入产出比最高的之一——它解决了大多数人放弃的难题。
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:
- 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)
- Right-click → "Move to other series" (移动到其他系列)
- think-cell automatically:
- Combines those segments into a single "Other" segment
- Places it consistently across all columns
- Updates the legend
- Reposition "Other" to a less-prominent location (typically top of stack)
- 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技巧:
- 按住Shift,点击最早年份的第一个低价值分段,然后点击最晚年份的最后一个低价值分段(选中小类别的矩形区域)
- 右键单击 → “移动到其他系列(Move to other series)”
- think-cell会自动:
- 将这些分段合并为一个“其他”分段
- 在所有柱形中保持位置一致
- 更新图例
- 将“其他”重新定位到不太显眼的位置(通常是堆积图的顶部)
- 此时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:
- Create primary stacked column chart
- Duplicate (Ctrl+D), place adjacent
- Strip the duplicate down: remove all data labels, axes, gridlines
- Recolor the duplicate's segments in white or a very light shade
- Move duplicate to fill the gap between original chart segments
- 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默认行为:它可以自动在不同柱形的同色分段之间绘制连接线。
进阶润色——分段之间的填充区域:
麦肯锡演示文稿中常见的“填充连接线”效果(分段之间的渐变)制作方法如下:
- 创建主堆积柱形图
- 复制(Ctrl+D),放在相邻位置
- 精简复制的图表:移除所有数据标签、坐标轴、网格线
- 将复制图表的分段重新着色为白色或非常浅的色调
- 移动复制的图表,填充原图分段之间的间隙
- 将图表背景线设为白色;最终效果是在时间点之间形成“填充流”
更简洁的替代方案:直接使用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:
- Stacked or grouped column chart
- Add "Plan" series alongside "Actual"
- Right-click Plan series → marker type → value line
- Adjust line length (drag handle) so it spans the column width
- Add label "预算 / Plan" with one line as anchor
适用场景:将计划值显示为浮动参考线,叠加在实际值柱形上方。
14版本之前的替代方案:将计划数据转换为折线图,将标记设为“长条形”,移除折线段,调整标记大小以匹配柱宽。操作繁琐,很少有用户掌握。
think-cell 14及以上版本原生功能:右键单击“计划”系列 → 更改标记类型 → 值线(静值线 / 进值线)。每个计划数据点都会变成一条浮动在对应数值上的水平线,仅属于其所在的柱形。
制作步骤:
- 堆积或簇状柱形图
- 在“实际”系列旁添加“计划”系列
- 右键单击“计划”系列 → 标记类型 → 值线
- 调整线条长度(拖动手柄),使其覆盖整个柱宽
- 添加“预算 / 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":
- think-cell options → Enable data table for chart (must be turned on)
- Add a row to the chart's underlying data table containing the variance %
- Right-click the variance row → "Move below chart" (移入到表格下方)
- think-cell renders this row as a labeled strip directly under the bars, perfectly aligned column-by-column
- 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及以上版本原生功能——“为图表启用数据表”:
- think-cell选项 → 为图表启用数据表(必须先开启)
- 在图表的底层数据表中添加一行,包含差异百分比数据
- 右键单击差异行 → “移入到表格下方(Move below chart)”
- think-cell会将这行渲染为带标签的条带,直接显示在柱形下方,与每个柱形完美对齐
- 样式:设置为百分比格式;如有需要,可给正/负值设置不同颜色
这解决了长期以来迷你表格与图表对齐的痛点。
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 (指数化):
- Pre-process data in Excel: divide each series by its first value × 100
- Now all series start at 100; differences are %-relative
- Insert think-cell line chart
- 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为基准):
- 在Excel中预处理数据:将每个系列除以其第一个值再乘以100
- 此时所有系列都从100开始;差异为相对百分比
- 插入think-cell折线图
- 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
.style自定义think-cell样式:你的专属.style
文件
.styleEvery consulting firm using think-cell has a custom file that
defines:
.style- Default colors (primary, accents, segment palette)
- Default border weights
- Default fonts
- Per-chart-type style overrides
Killer move: build your own file.
.style每家使用think-cell的咨询公司都有自定义的文件,定义了:
.style- 默认颜色(主色、强调色、分段调色板)
- 默认边框粗细
- 默认字体
- 各图表类型的样式覆盖规则
杀手锏:创建你自己的文件。
.styleHow to Customize
如何自定义
- Open the Insert → think-cell → Load Style File dropdown — note that default is "Default" (literally "默认格式")
- Locate the style files folder (typically or under
C:\Program Files\think-cell\styles\)%APPDATA%\think-cell\ - Open the default file in a text editor
.style - Reference: think-cell home page → Resources → Style File Format documentation lists every key
- Edit colors using the format or theme-color references
#RRGGBB - Save as in the same folder
myname.style - Back in PowerPoint: think-cell → Load Style File → myname.style
- 打开插入 → think-cell → 加载样式文件下拉菜单——注意默认选项是“Default”(字面意思是“默认格式”)
- 找到样式文件文件夹(通常是或
C:\Program Files\think-cell\styles\目录下)%APPDATA%\think-cell\ - 在文本编辑器中打开默认的文件
.style - 参考资料:think-cell官网 → 资源 → 样式文件格式文档列出了所有配置项
- 使用格式或主题颜色引用编辑颜色
#RRGGBB - 在同一文件夹中另存为
myname.style - 回到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 youris loaded into a PPT and you save the file as a.styletemplate, the style is embedded in the file. Recipients without your.potxfile still see the styled charts correctly — but they cannot extract your.styleto reuse elsewhere..style
This means:
- You can ship styled decks safely; recipients see your style
- You don't have to share the file unless you want them to apply it elsewhere
.style - Many consulting firms treat their as IP — never share externally
.style
一旦你的文件加载到PPT中,并且你将文件另存为.style模板,样式就会嵌入到文件中。没有你的.potx文件的收件人仍然可以正确查看带样式的图表——但他们无法提取你的.style文件在其他地方复用。.style
这意味着:
- 你可以安全地发送带样式的演示文稿;收件人能看到你的样式
- 你不必分享文件,除非你希望他们在其他地方应用该样式
.style - 许多咨询公司将其文件视为IP——切勿对外分享
.style
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
.style7. 日常工作中忽视.style
文件
.styleIf you make charts daily, time spent on a pays back within days.
Skipping this is the most common reason individual consultants' charts
look amateur compared to firm-shop output.
.style如果你每天都要做图表,花在文件上的时间几天就能回本。个体咨询师的图表看起来不如公司专业团队出品的,最常见的原因就是忽略了这一点。
.styleQuick 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 loaded (not default)
.style - 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
快速参考:词汇表
| 中文 | English | What it is |
|---|---|---|
| 瀑布图 | Waterfall | Bridge chart for value walks |
| 堆积柱状图 | Stacked column | Composition + trend |
| 干特图 | Gantt | Project timeline |
| Mekko / 马赛克图 | Marimekko | Variable-width stacked column |
| 差异线 | Difference connector | Marks delta between two bars/segments |
| CAGR 箭头 | CAGR arrow | Auto-computed growth rate label |
| 静值线 / 进值线 | Value line | Horizontal floating reference line (think-cell 14+) |
| 移动到其他系列 | Move to other series | "Other" bucket trick for small segments |
| 表格下数据 | Below-chart data row | Variance %, sub-table aligned to chart (think-cell 14+) |
| .style 文件 | Style file | think-cell's customization mechanism |
| 加载样式文件 | Load style file | Apply a .style to current PPT |
| 指数化 | Index-to-100 | Pre-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 file | think-cell的自定义机制 |
| 加载样式文件 | Load style file | 为当前PPT应用.style文件 |
| 指数化 | Index-to-100 | 处理跨数量级折线图的预处理技巧 |