Visualizing data in Excel: choose the right chart

Visualizing data in Excel works best when one chart answers one business question: what changed, which category is largest, or how the business mix shifted. Start with a checked summary, choose the chart for that question and prove that its values still add to the export.

A clear picture depends on the rows behind it. If two versions of the workbook disagree, complete the comparison of the two exports before choosing colors or labels.

Choose the question before the chart

The same sales file can support several valid pictures. Write the question as a sentence before selecting the range.

These choices follow the distinctions in Microsoft's chart type guide: line charts show trends, bar charts compare items, and stacked columns show contributions to a total. A percentage stacked column normalizes each period, so keep the dollar totals visible beside it.

Covirage is not affiliated with Microsoft.

Avoid choosing a chart because the workbook has a convenient button for it. A ranking is easier to read when categories are sorted by value, while a monthly trend needs chronological order. Those are different sorting decisions, even when the values come from the same file.

Start with a small, reconciled summary

Consider a US equipment distributor's sales summary for January through March 2026. Each row is one complete month. Revenue is net of credits, in USD, and the product lines do not overlap. The summary has already been tied to the sales export for those periods.

Put the headers in A1:E1 and the monthly rows in rows 2:4. Keep the quarter total in row 5, outside the chart range.

Calculate each monthly total in E2 and fill down to E4:

=SUM(B2:D2)

For the quarter, enter the following in B5 and fill across through E5:

=SUM(B2:B4)

Then prove that the sum across product totals equals the sum down monthly totals:

=SUM(B5:D5)-SUM(E2:E4)

The result must be zero. Equipment of $405,000 plus service of $245,000 plus parts of $170,000 equals $820,000, which also equals the monthly totals of $250,000, $270,000 and $300,000.

Before using a larger export, review inconsistent categories and missing amounts with the guide to Excel data cleaning tools. A second spelling of a product line can create an extra series that looks like a real business segment.

Show the trend with a line chart

Select the month labels and the total revenue values for the monthly rows. Choose Insert > Recommended Charts, review the options and select a line chart. Microsoft's chart creation instructions describe this selection and preview workflow.

Keep the source restricted to January through March. Do not include the quarter total as another month. Label the vertical axis as revenue in USD and title the chart with the measure and period.

The end-to-start change is:

=E4/E2-1

Format that cell as a percentage. Revenue rose from $250,000 to $300,000, a 20.0% increase. The calculation uses January as the denominator; dividing by March would answer a different question.

The chart supports the statement that monthly revenue increased across the displayed periods. It does not establish seasonality, explain why customers bought more or show whether collections improved. Three monthly observations are a limited view of the business, so keep that boundary in the caption.

Rank the product lines using the same rows

Create a separate two-column summary with product line and quarter revenue. Link each amount to the quarter cells rather than typing it again.

Use these category rows for a horizontal bar chart, ordered from largest to smallest. Start the value axis at zero so bar lengths show the relative amounts directly. Display the units once in the axis or title, and keep full values in the supporting table.

Equipment is the largest line. The chart does not say it is the most profitable line because the source contains revenue, not cost. That distinction matters when a sales leader uses the chart to assign attention or budget.

If you need a chart connected to a filterable summary, use the separate PivotChart build guide. The reconciliation above remains the control regardless of how the chart is created.

Show mix without losing the total

For a stacked column chart, select A1:D4. Use months as the categories and equipment, service and parts as the series. Exclude column E because its total is already represented by the combined segments.

March's mix follows directly from its row:

For equipment's March share, use:

=B4/$E4

The fixed E column keeps the same denominator when you copy the formula across. Percentages here are shown to one decimal place; calculations use the unrounded amounts.

Use ordinary stacked columns when total dollars matter. Use percentage stacked columns when composition is the question, then show the monthly revenue table beside the chart. Otherwise, equally tall columns can hide growth in the business.

Where it goes wrong

• Plotting both details and totals. Equipment, service and parts already contain the full revenue amount. Adding total revenue as another stacked series duplicates it.
• Mixing incomplete periods. A partial month beside a closed month can look like a decline. Label the cutoff and compare equivalent periods.
• Changing category colors. Keep the same product line the same color across trend, ranking and mix charts.
• Replacing missing amounts with zero. A missing export is not evidence that sales stopped. Resolve the gap or mark it clearly.
• Making the headline stronger than the rows. A revenue chart cannot prove profitability or explain customer behavior. Use the worked order exploration when the next question requires looking below the summary.

Check the figures on your own file in Covirage

Bring your sales workbook or a sample of your own export to Covirage. Covirage maps the columns, its tools compute and check the totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring the file behind your next chart.

See how this fits Excel analysis for business teams.