The combo chart is the single most useful chart type in any finance dashboard. The pattern is: bar for the absolute number, line for the relative number, secondary axis for the scale difference. The four examples below are the ones worth building into every report. The four tips are the ones that turn the combo chart from a default into a senior-built chart.
The four examples
Revenue and margin %
Primary: Revenue (bar, primary axis)
Secondary: Margin % (line, secondary axis)
The most common combo chart in any finance dashboard. The bar shows the absolute number; the line shows the trend of the percentage. Together they answer: are we growing revenue at constant margin, growing revenue at expanding margin, or growing revenue at compressing margin?
Sales and forecast
Primary: Actual sales (bar, primary axis)
Secondary: Forecast (line, secondary axis)
The bar shows what happened; the line shows what was expected. The gap is the variance. The senior colours the bars green when above forecast, red when below, and neutral when on target.
Cost and headcount
Primary: Total cost (bar, primary axis)
Secondary: Headcount (line, secondary axis)
The bar shows the spend; the line shows the team size. The combination answers: are we scaling efficiently? Cost per headcount is implied by the chart; the senior adds a third line for the implied cost per headcount.
Production and yield
Primary: Production volume (bar, primary axis)
Secondary: Yield % (line, secondary axis)
The bar shows the volume; the line shows the quality. The combination answers: are we producing more while maintaining quality, or are we sacrificing quality for volume? The senior uses this on every manufacturing dashboard.
The four usage tips
Use the secondary axis for percentages
The senior uses the secondary axis for any percentage, ratio, or index. The primary axis is always the absolute value (revenue, cost, volume). The secondary axis is always the relative value (margin %, growth %, yield %). The two-axis convention is the senior-built dashboard standard.
Choose the chart type by the message
Bar for absolute values, line for trends, area for cumulative, scatter for correlation. The senior picks the chart type by the message, not by the data. The same revenue data can be a column chart (period comparison), a line chart (trend), or an area chart (cumulative). The choice depends on what the reader needs to see.
Limit to two to three metrics
Beyond three metrics, the chart is unreadable. The senior uses two to three metrics per chart, one chart per row, and a Slicer to filter. The pattern keeps the dashboard at one screen, with each chart answering a single question.
Colour-code by variance
For variance charts (actual vs target, actual vs forecast), the senior colours the bars by variance - green when above, red when below, neutral when on target. The colour does the talking; the chart shows the gap.
From combo to dashboard
The combo chart is one element of a senior-built dashboard. The full pattern: five tiles per row, one chart per tile, one Slicer per dashboard. The senior ships a 5-tile dashboard for the seven CFO reports. The combo chart appears on every row - revenue + margin, cash + burn, production + yield, sales + forecast. The pattern is consistent and the reader learns to read the dashboard in 30 seconds.
Step-by-step: building a revenue + margin combo chart
Six steps. (1) Lay out the source data in three columns: Month, Revenue, Margin%. Revenue in the same row as Margin% so the chart series can pair them. (2) Select the data → Insert → Combo Chart → Clustered Column - Line on Secondary Axis. (3) Right-click the line series → Format Data Series → confirm Plot on Secondary Axis. (4) Right-click the secondary axis → Format Axis → Minimum 0%, Maximum 100% (or the natural bounds of your data). (5) Add data labels to the bar for the absolute value. (6) Add a chart title that states the question - "Are we growing revenue at constant margin?" The chart answers the question visually.
Common pitfalls
Five pitfalls to avoid. (1) Putting both series on the primary axis - the smaller series disappears. Always use the secondary axis when the scales differ by 10x or more. (2) Using a 3-D effect - Excel's 3-D chart options distort the visual and hide the data. Use flat 2-D only. (3) More than three series - the chart becomes unreadable. Two to three is the senior's limit. (4) Putting the legend at the right by default - move it to the bottom or top. The right-hand legend wastes horizontal space. (5) Colours that don't match the data - green for "above target", red for "below target", neutral for "on target". The colour does the talking.
Performance notes
Combo charts on 1K-row datasets render in under a second. On 100K-row datasets, expect 3-5 second refresh on Power Query and 1-2 second chart redraw. On 1M+ row datasets, switch to Power BI - Excel's chart engine is single-threaded and struggles above 500K visible points. The senior's rule: if the combo chart is part of a daily refresh on 100K+ rows, store the dataset in Power Pivot (xVelocity in-memory engine) rather than a regular range. The refresh drops from 30 seconds to under 2.
Variations the senior ships
Three variations on the standard combo. (1) Actual vs target - bar for actual, horizontal line for target. The target line stays flat across all months; the bars either sit above or below. (2) Variance vs plan - bar for variance (positive or negative), line for cumulative variance. (3) Two metrics, two scales - bar for absolute (₹ Lakhs) on primary, line for percent (%) on secondary. The pattern is the foundation of every CFO dashboard the senior builds.
How this fits the senior-built dashboard
The combo chart is one tile on a 5-tile dashboard. The other four tiles use other chart types - bar for variance, line for trend, area for cumulative, KPI tile for the headline number. The full pattern is documented on designing a KPI dashboard and is the standard ship pattern for every CFO dashboard we build in our dashboard development engagement. The combo chart is the most reused chart type across the engagement - every financial dashboard has at least two combo charts on the first row.
