Blog · Board and management reporting
Choose charts by the business comparison they need to show. Work through revenue trends, regional shares, and variance contributions using one reconciled workbook example.
Business intelligence charts should match the comparison a reader needs to make: change over time, differences between segments, shares of a total, or contributions to a variance. Start with a reconciled measure and a decision, then choose the display. The same revenue rows can answer several different questions without changing the underlying arithmetic.
For the broader definition, see what business intelligence is. This guide addresses chart selection; data visualization tools covers choosing software for the work.
Write the question as a sentence someone can act on. “Which region needs a sales review?” needs a regional comparison. “How did company revenue move?” needs time order. “Which regions account for the change?” needs an additive bridge.
| Business question | Useful chart | Measure to prepare | Decision it supports |
|---|---|---|---|
| How is revenue moving over time? | Line | Net revenue for each period | Investigate a persistent change |
| Which region has the most revenue? | Horizontal bar | Same-period revenue by region | Compare scale across territories |
| Which region is growing fastest? | Bar or dot | Change divided by prior revenue | Investigate relative performance |
| What contributed to the company change? | Waterfall | Current minus prior revenue by region | Assign follow-up by contribution |
| How is the sales mix changing? | Stacked columns | Regional revenue by period | Examine changing composition |
| Are two measures related? | Scatter | Paired observations at the same row level | Select cases for investigation |
Microsoft's chart type guide describes line charts for trends at equal intervals and bar charts for comparisons among items. The choice still depends on the question: a chart type does not determine the meaning of its source values.
A US distributor exports posted invoice revenue by region for August and September 2026. The figures are net of credits and all amounts are USD. Each invoice belongs to one region; the regional totals reconcile to the posted invoice register for each month.
| Region | August revenue (USD) | September revenue (USD) | Change (USD) | Growth | September share |
|---|---|---|---|---|---|
| East | 100,000 | 120,000 | 20,000 | 20.0% | 42.9% |
| Central | 80,000 | 70,000 | -10,000 | -12.5% | 25.0% |
| West | 60,000 | 90,000 | 30,000 | 50.0% | 32.1% |
| Company | 240,000 | 280,000 | 40,000 | 16.7% | 100.0% |
The table provides the values for every chart discussed below. Dollar calculations are exact; displayed percentages are rounded to one decimal place after calculation.
Revenue change = September revenue − August revenue
Growth = Revenue change / August revenue
September share = Regional September revenue / Company September revenue
If the table begins in A1, D2 is =C2-B2, E2 is =D2/B2, and F2 is =C2/SUM($C$2:$C$4). Fill those formulas through row 4. Calculate company growth from the totals, =SUM(D2:D4)/SUM(B2:B4), rather than averaging regional growth percentages.
When starting from invoice rows, use the same region and month conditions for every aggregation. Microsoft's SUMIFS documentation explains how to sum records meeting multiple criteria. Reconcile that summary before selecting its cells for a chart.
A September revenue bar chart places East first at $120,000, followed by West at $90,000 and Central at $70,000. It answers where the business is largest. Start the bar value axis at zero so bar lengths retain their proportional meaning.
A growth chart gives a different ranking: West at 50.0%, East at 20.0%, and Central at negative 12.5%. West grows fastest from a smaller starting base. Neither ranking contradicts the other; they use different measures.
Label a percentage chart as growth, with August as its denominator. A label saying only “performance” leaves readers to guess whether the bars show revenue, growth, or margin. The sales operations analyst prepares the summary, while the revenue owner approves the measure and regional assignments.
For a one-off management question, ad hoc business intelligence explains how to bound the analysis before preparing the view.
A waterfall can start at August revenue of $240,000, add East's $20,000, subtract Central's $10,000, and add West's $30,000 to end at September revenue of $280,000.
| Bridge step | Contribution (USD) | Running revenue (USD) | Share of net change |
|---|---|---|---|
| August starting total | 240,000 | ||
| East change | 20,000 | 260,000 | 50.0% |
| Central change | -10,000 | 250,000 | -25.0% |
| West change | 30,000 | 280,000 | 75.0% |
| Net change | 40,000 | 280,000 | 100.0% |
The proof is $20,000 minus $10,000 plus $30,000 equals $40,000. Each contribution share divides by that net change. Central's negative share is meaningful because it offsets growth elsewhere.
This bridge attributes the change to regions. It does not establish whether West grew through higher prices, more orders, or a customer moving territories. The regional manager owns that investigation and should bring supporting transaction evidence.
A line from $240,000 in August to $280,000 in September shows an increase of 16.7%. With only the observations supplied here, it cannot establish a sustained trend. Bring additional comparable months before describing seasonality or an enduring improvement.
A September composition view shows East at 42.9%, Central at 25.0%, and West at 32.1%. Shares describe relative size. They cannot tell a manager whether company revenue is rising, so retain the dollar total beside them.
For recurring comparisons, automated business intelligence covers repeatable definitions and checks before each review.
Covirage is not affiliated with Microsoft.
Bring a sample of your own revenue workbook to Covirage; it maps the columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See self-service analytics for the supporting business use case.
A horizontal bar chart usually makes a single departmental measure easy to compare. Use the same period and calculation for every bar, sort deliberately, and label the units. Add a separate rate measure when department size affects the interpretation.
Use a line chart for a measure observed through ordered time periods, such as monthly revenue. Keep the intervals clear and show missing periods as missing. A short series supports a period comparison but provides limited evidence about a sustained trend.
A waterfall can show which segments contributed to an additive revenue change. It does not establish the business cause by itself. Investigate prices, quantities, customer activity, and other evidence before turning a segment contribution into a causal explanation.