18.1 Chart Types and Selection

Financial Modeling & Valuation Analyst FMVA

Track your progress as you read

Finished sections get a check mark.

1 Introduction

Current Exam Facts Program Path and How to Use This Guide

2 Chapter 1: Accounting Foundations

1.1 Accounting Principles 1.2 Reading Financial Statements 1.3 Accounting Decisions in Models

3 Chapter 2: Time Value and Capital Budgeting

2.1 Time Value of Money 2.2 NPV, IRR, and Decision Rules 2.3 Capital Budgeting Cash Flows

4 Chapter 3: Cost of Capital

3.1 Capital Structure 3.2 CAPM, Beta, and Cost of Equity 3.3 WACC

5 Chapter 4: Profitability and Returns

4.1 Profitability and Margins 4.2 Returns and DuPont Analysis 4.3 Per-Share Metrics and Growth

6 Chapter 5: Liquidity, Leverage, and Cash Flow

5.1 Liquidity and Working Capital Metrics 5.2 Leverage, Coverage, and Credit 5.3 Cash Flow Statement Analysis

7 Chapter 6: Excel Fundamentals

6.1 Shortcuts, Setup, and Navigation 6.2 Core Formulas and Error Handling 6.3 Named Ranges and Workbook Hygiene

8 Chapter 7: Excel Lookups and Financial Functions

7.1 Lookup Functions 7.2 Conditional Aggregations 7.3 Financial Functions

9 Chapter 8: Excel What-If Analysis and Auditing

8.1 Goal Seek and Data Tables 8.2 Formula Auditing and Protection

10 Chapter 9: Financial Modeling Guidelines

9.1 Model Structure and Layout 9.2 Color Conventions and Formatting 9.3 Integrity Checks and Documentation

11 Chapter 10: Three-Statement Modeling

10.1 Articulating the Three Statements 10.2 Building the Income Statement 10.3 Building the Balance Sheet and Cash Flow Statement

12 Chapter 11: Circularity and Model Audit

11.1 Circular References and Iteration 11.2 Auditing and Balancing a 3-Statement Model

13 Chapter 12: Operational Modeling

12.1 Revenue and Operating Drivers 12.2 Working Capital Modeling 12.3 Capex and Depreciation

14 Chapter 13: Debt Schedules, Scenarios, and Sensitivity

13.1 Debt and Interest Schedules 13.2 Scenario Analysis 13.3 Sensitivity Analysis

15 Chapter 14: Valuation Foundations

14.1 Valuation Methods and Enterprise Value 14.2 Unlevered Free Cash Flow

16 Chapter 15: DCF Valuation

15.1 DCF Structure, WACC, and Mid-Year Convention 15.2 Terminal Value and the Equity Bridge

17 Chapter 16: Comparable Valuation

16.1 Trading Comps and Multiples 16.2 Precedent Transactions and the Football Field

18 Chapter 17: Budgeting and Forecasting

17.1 Budget Types 17.2 Forecasting Techniques 17.3 Rolling Forecasts and Variance Analysis

19 Chapter 18: Presentation and Visuals

18.1 Chart Types and Selection 18.2 Dashboards and Data Visualization 18.3 PowerPoint and Pitchbooks 18.4 Presenting Model Outputs

20 Chapter 19: Professional Ethics and Qualitative Analysis

19.1 Professional Ethics 19.2 Qualitative Business Analysis

18.1 Chart Types and Selection

Key Takeaways Explain This Topic AI

Match the chart to the question: clustered column or bar for comparison, line for time series, stacked for mix, scatter for correlation, waterfall for NI or EV bridges, combo for actual versus budget.

Do not use a pie for more than three or four slices; Apex's twelve SG&A cost centers belong on a sorted bar, not a donut.

A dual-axis chart has independent scales — a 40-basis-point margin move can be drawn as tall as Apex's $6.1 million revenue beat.

Direct labels beat legends; CFI's Excel Data Visualization and Dashboards course drills data labels and display units in $ millions.

Apex East, Central, and West actuals of $38.5, $30.1, and $17.5 million versus $36, $28, and $16 million budget analogs are a clustered column, not a pie of 2026 mix.

Last updated: August 2026

Why Chart Choice Is an FMVA Skill

Excel Data Visualization and Dashboards is core course 13 on CFI's 15-course 2026 list. PowerPoint & Pitchbooks is core 14 and was refreshed on 27 February 2026 . Together they carry Presentation & Visuals , about 5% of the final — not a trivia sidecar. A modeling case that dumps a raw three-statement sheet, or a multiple-choice item that asks which chart belongs on a variance pack, is this chapter. Elective courses such as Communication and Presentation Skills for Finance Professionals (which replaced Presentation of Financial Information on 27 February 2026) can count toward the three-elective eligibility rule, but elective content is not tested . Stay on the two cores.

A chart is a sentence in picture form. The exam tests whether you pick the sentence that matches the question, not whether you can add 3-D bevels. CFI's dashboard course has you build two complete dashboards with clustered columns, line charts, stacked mix charts, waterfalls, area charts, and a football field . Those are the types to know by name, by use, and by trap.

This chapter uses two running files. Apex Housewares (Chapter 17) is the FP&A pack: FY2026 actual revenue $86.1 million versus a lock of $80.0 million . Alder Coatings (Chapters 15–16) is the valuation pack: Gordon year-end enterprise value $2,071 million , equity $1,301 million , $26.02 per diluted share.

Column and Bar Charts for Comparison

A column chart (vertical bars) or bar chart (horizontal bars) compares magnitudes across categories . Use columns when categories are few and the axis is time or a short label. Use bars when labels are long — region names, peer companies — so the type remains readable.

Apex's FY2026 bottom-up regional build versus the FY2025 run-rate that sat under the $80 million lock:

Region FY2025 / budget analog ($ m) FY2026 actual ($ m) Change
East 36.0 38.5 +2.5
Central 28.0 30.1 +2.1
West 16.0 17.5 +1.5
Total 80.0 86.1 +6.1

A clustered column with two series — budget analog and actual — answers who beat the lock in one glance. East, Central, and West all rose. A pie of 2026 actuals cannot show the beat, because a pie has no budget series.

Exam trap: a 3-D column. Depth adds no data and hides the West bar. CFI formatting drills 2-D charts, data labels , and display units ($ millions), not extrusion.

Line Charts for Time Series

A line chart shows change over a continuous time axis . Apex's annual revenue: FY2023 $72 million , FY2024 $76 million , FY2025 $80 million , FY2026 $86.1 million . Connecting those four points is the right picture of trend. Four isolated columns also work; the line is better when you want slope, and it is the default for monthly series (12–36 points).

Do not use a line for unordered categories (East / Central / West). Those are not a time sequence. A line between East and Central invents a path that does not exist.

Stacked Charts for Mix

A stacked column or stacked bar shows composition and total together. CFI's dashboard course explicitly builds a stacked revenue chart . Suppose Apex's $86.1 million splits:

Product FY2025 ($ m) Share FY2026 ($ m) Share
Core housewares 50.0 62.5% 51.7 60.0%
Premium 18.0 22.5% 21.5 25.0%
Seasonal 12.0 15.0% 12.9 15.0%
Total 80.0 100% 86.1 100%

Two stacked columns (2025, 2026) show the total rising $6.1 million and Premium's mix rising from 22.5% to 25.0% . That mix shift is why average selling price went from $40 to $41 in Chapter 17 — not necessarily a list-price increase.

100% stacked columns drop the total and show only mix. Use them when the question is mix, not dollars. Do not 100% stack a P&L waterfall; you would hide that revenue is $86.1 million.

Stacked area is CFI's expense-analysis tool on Dashboard 1. It is a mix-over-time chart. It is not a replacement for a variance waterfall.

Scatter Charts for Correlation

A scatter chart plots two numeric variables to show association, not time. Example: regional marketing spend versus regional revenue. East spent $1.8 million and printed $38.5 million; Central $1.2 million and $30.1 million; West $0.9 million and $17.5 million. The cloud is three points — too few to claim a law — but the chart type is still scatter, not a line.

Exam trap: drawing a line chart through those points and calling it causation. Scatter does not prove that another $0.1 million of ads would add a mechanical amount of sales. It shows whether the two series move together .

Waterfall Charts for Bridges

A waterfall (bridge chart) starts at a total, adds and subtracts signed steps, and lands on a new total. CFI's dashboard course builds a waterfall as a named lesson. Two FMVA-native uses:

1. Net-income (P&L) bridge for Apex FY2026 actuals (compact teaching P&L; SG&A actual $21.5 million , depreciation and amortization $3.0 million , interest $1.8 million , tax 25%):

Step Amount ($ m) Running
Revenue 86.1 86.1
− COGS (51.45) 34.65
− SG&A (21.5) 13.15
− D&A (3.0) 10.15 EBIT
− Interest (1.8) 8.35 EBT
− Tax at 25% (2.09) 6.26 NI

The first and last columns are totals (connectors). The middle columns are floating decrements. That is a net-income waterfall .

2. Enterprise-value to equity bridge for Alder Coatings:

Step Amount ($ m) Running
Enterprise value (Gordon year-end) 2,071 2,071
− Debt (800) 1,271
− Preferred (50) 1,221
− NCI (30) 1,191
+ Surplus cash 90 1,281
+ Non-core investments 20 1,301 equity

$1,301 million / 50.0 million diluted shares = $26.02 . The waterfall is the equity bridge from Chapter 15 in chart form. A clustered column of those six signed items without a running total is not a bridge; it is a bar chart of ingredients.

Variance waterfalls (Chapter 17) are the third native use: +$4.0 million volume, +$2.1 million price, −$2.4 million COGS quantity, −$1.05 million COGS rate = +$2.65 million gross-profit variance.

Combo Charts for Actual Versus Budget

A combo chart overlays two chart types on one plot, usually columns plus a line . The CFI-native use is actual versus budget as clustered columns and a margin or growth percent as a line — or two column series (actual, budget) without a second axis at all.

Apex revenue: budget $80.0 million column, actual $86.1 million column, and a line for gross margin 40.0% budget versus 40.2% actual ($34.65 / $86.1). The columns answer the dollar question; the line answers the quality question. You do not need a second axis if you plot the margin as a separate small chart. If you do combine them, read the dual-axis warning next.

Loading diagram... Pick the chart that answers one question, then label it

Apex FY2026 regional revenue: budget analog vs actual ($ millions)

Avoid Pie Charts for More Than Three or Four Slices

A pie chart encodes share of a single total as angles. Humans compare angles poorly once the slice count rises. CFI-aligned rule for the exam: do not use a pie for more than three or four slices. Three-product Apex mix (Core 60%, Premium 25%, Seasonal 15%) is the outer acceptable case. Twelve SG&A cost centers is a pie of junk. Use a sorted bar for those twelve lines: the longest bar is the largest cost, and the axis still has dollars.

Pies also fail comparison across years. Two pies (2025 and 2026) force the reader to jump between images to see that Premium rose from 22.5% to 25.0%. Two stacked columns keep the total and the mix on one axis.

Donut charts are pies with a hole. Same slice-count rule. 3-D pies are never acceptable: they distort angle into perspective.

Dual-Axis Traps

A dual-axis (secondary axis) chart plots two series against independent scales. The trap is that the series look like they share a zero and a slope when they do not.

Worked distortion: Apex revenue $80.0 → $86.1 million (left axis scaled $78 to $88) and a quality metric that moved from 20.0% to 20.4% (right axis scaled 19.8% to 20.6%). Both lines shoot up the plot. The revenue beat is real (+7.6%). The 40-basis-point mix move is small. The chart lies by scale .

Worse: putting revenue in $ millions and WACC in percent on one dual-axis plot. Alder's $2,071 million enterprise value and 9.0% WACC do not belong on the same picture. They are not a time series together; they are an input and an output.

Exam-safe dual axis: same-context series that would otherwise be unreadable (units in thousands on the left and average selling price in dollars on the right), with both axes labeled , zero shown or disclosed , and a title that states the two scales. When in doubt, two charts .

CFI combo lessons (actual versus budget, growth-rate data on a stacked revenue chart) are not a license to dual-axis every dashboard. A combo chart can use a single axis when both series are dollars. The second axis is the exception, not the professional default.

Direct Labels Beat Legends

A legend off to the side forces the eye to decode color, then return to the bar. Direct labels — data labels on the series, or the series name at the end of the line — keep the number on the mark. CFI's dashboard course has an explicit lesson on adding totals with data labels . For a three-region clustered column, put 38.5 on the East actual bar. You may still keep a small legend if you have two series (Budget / Actual), but the values should sit on the columns.

Display units: if the model is in $ thousands , the chart axis must say $ thousands . Alder is in $ millions . Writing $2,071 with no unit, or $2,071,000,000 on a pitchbook, is an integrity miss (section 18.4).

Chart-Selection Map

Question Chart Not this
How do regions compare to budget? Clustered column or bar Pie
How did revenue move over four years? Line (or column) Scatter
How did product mix change? Stacked column Pie pair
Do ads and sales move together? Scatter Line through categories
How do we get from EV to equity, or NI from revenue? Waterfall Clustered ingredients
Actual vs budget plus a margin? Combo (or two charts) Dual-axis with hidden zeros
Twelve SG&A lines? Sorted bar Pie or donut

Pick the chart that answers one question . Section 18.2 turns that rule into a dashboard.

Exam traps on chart types

A pie of twelve cost centers, or two pies to compare years.

A 3-D column that hides the smallest region.

A line chart through East–Central–West as if they were time.

A dual-axis of dollars and WACC, or of dollars and a 40-basis-point margin tick drawn full height.

Calling a clustered column of bridge ingredients a waterfall because the title says Bridge.

Leaving the legend as the only decoder and omitting $ millions on the axis.