Blog · Board and management reporting
Business data visualization makes trends, category mix and exceptions easier to compare. Use a worked revenue example to choose a chart, check its figures and connect the result to a business decision.
Business data visualization turns checked business figures into comparisons people can use: what changed, where it changed and what deserves attention. Choose the chart after defining the decision and reconciling the table behind it. A clear picture of an incomplete measure can still lead to the wrong action.
A sales director might ask whether revenue growth came from direct customers or resellers. A finance manager might ask whether that growth produced more gross profit. Those questions use the same export but need different comparisons.
Write the question above the table before making a chart. Include the reporting period, unit, business scope and person who can act on the answer. “March revenue by channel, USD, posted sales only” is a usable specification. “Sales performance” leaves too much open.
Keep software selection separate from this task. The data visualization tools guide covers choosing a reporting approach; here the job is to choose the comparison and prove its figures.
Consider a fictional US distributor reviewing January through March 2026. Its posted sales export contains transaction ID, posting date, channel, net revenue and product cost. Credit memos reduce revenue and the associated cost where applicable. All amounts below are USD.
The table groups those rows by month and channel. Gross profit is net revenue less product cost; gross margin divides gross profit by net revenue.
| Month | Channel | Net revenue (USD) | Product cost (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|
| January | Direct | 120,000 | 72,000 | 48,000 | 40.00% |
| January | Reseller | 80,000 | 56,000 | 24,000 | 30.00% |
| February | Direct | 126,000 | 75,600 | 50,400 | 40.00% |
| February | Reseller | 84,000 | 58,800 | 25,200 | 30.00% |
| March | Direct | 132,000 | 79,200 | 52,800 | 40.00% |
| March | Reseller | 108,000 | 81,000 | 27,000 | 25.00% |
| Quarter total | 650,000 | 422,600 | 227,400 | 34.98% |
The total margin is 227,400 / 650,000, rounded to two decimal places. It is calculated from totals rather than by averaging the displayed percentages. The gross profit margin guide explains the accounting boundary in more detail.
For a worksheet with these six detail rows in rows 2 through 7, revenue in C and cost in D, enter this profit formula in E2:
=C2-D2
In F2, calculate margin:
=IF(C2=0,"",E2/C2)
Copy both formulas down. Group transaction-level exports with consistent criteria; Microsoft's SUMIFS documentation explains how the function sums values meeting multiple criteria. Preserve the ungrouped export so a disputed bar can be traced back to its transactions.
A line chart makes consecutive monthly values easy to follow. Microsoft describes line charts as suited to trends at equal intervals, while bar charts compare individual categories.
Roll up the source rows first:
| Month | Net revenue (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|
| January | 200,000 | 72,000 | 36.00% |
| February | 210,000 | 75,600 | 36.00% |
| March | 240,000 | 79,800 | 33.25% |
March revenue grew by (240,000 - 210,000) / 210,000 = 14.29%, rounded to two decimal places. Gross profit grew by (79,800 - 75,600) / 75,600 = 5.56%. The different rates matter: a rising revenue line does not establish improving profitability.
Show revenue and margin in separate, aligned views. Label dollars and percentages clearly. A reader should not have to decode an unlabeled second axis to understand why profit grew more slowly.
Use bars to compare March's channels. Direct revenue is $132,000 and reseller revenue is $108,000. Add a neighboring margin table or a separate margin comparison: direct remains at 40.00%, while reseller margin is 25.00%.
The larger revenue bar identifies scale. The margin comparison identifies economics. Keeping both makes the sales conversation more precise: investigate reseller pricing, discounts and product costs before setting a response.
A composition view answers a different question: what share of revenue came from each channel? Resellers contributed 80,000 / 200,000 = 40.00% in January and 108,000 / 240,000 = 45.00% in March.
That is a rise of 5.00 percentage points. A percentage composition chart can show the shift, but include revenue totals beside it. Equal-height percentage columns otherwise conceal the change from $200,000 to $240,000.
An exception table can be more useful than another chart. Suppose the sales director uses 30.00% as the internal reseller margin target for this review. It is a company assumption, not an industry benchmark.
| March reseller check | Calculation | Result |
|---|---|---|
| Target gross profit (USD) | 108,000 × 30.00% | 32,400 |
| Actual gross profit (USD) | 108,000 - 81,000 | 27,000 |
| Gap to target (USD) | 32,400 - 27,000 | 5,400 |
The $5,400 gap frames an investigation. It does not prove that a price increase would recover that amount without affecting volume. Assign the channel owner to inspect the transactions and report what explains the difference.
The monthly revenue totals must add to $650,000, matching the channel table and the filtered source export. Product costs total $422,600; subtracting them leaves $227,400 of gross profit. The difference between the grouped total and the source control should be zero.
Record filters beside the visual: posted status, period, currency and treatment of credits. Keep missing channels visible as an exception until someone resolves them. For recurring reports, assign ownership of measures and finished reports so definitions do not change silently between meetings.
Covirage is not affiliated with Microsoft.
Bring a sales workbook or Google Sheet with dates, categories, revenue and the relevant costs. Covirage maps the columns, and its tools compute and check the underlying figures; the external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See self-service analytics for the business questions those checked comparisons support.
Its purpose is to make a business comparison easier to understand and act on. A useful visual shows what changed, how much it changed and which part of the business explains it. The underlying table must still establish the numbers.
Use a line chart for revenue across consecutive periods and a bar chart for revenue across channels, customers or products. When comparing margin as well, provide a separate aligned view so dollars and percentages retain clear scales.
Use enough charts to answer the decisions in the report. A useful starting point is a trend, a category comparison and an exception view. Remove a chart when it repeats another comparison or cannot be tied to a question.
The business owner should define the question and action. Finance or the relevant reporting owner should approve the measure, period and source totals. The person preparing the chart should preserve the table and document filters so the comparison can be reproduced.