Chart the summary, not the rows
Total a list of orders by region with SUMIF, chart the totals, and watch the whole chain update. Intermediate · 5 min · SUMIF, Column chart, Summary table
Real data is usually a long list: one row per order, per ticket, per visit. A chart of the raw rows shows twelve columns in no useful order, and answers nothing.
The question people ask is about groups: how much did each region sell? So the work has two steps. First summarise the list into a small table, one row per group. Then chart the small table.
Because the summary is made of formulas and the chart is tied to the summary, the three stay in step: change one order, and the total and the chart both follow.
Steps
Twelve orders on the left, one row per region on the right. In
E2:E5, total each region's sales: enter=SUMIF($A$2:$A$13, D2, $B$2:$B$13)inE2and copy it down.Chart the summary, not the list. Select
D1:E5, click Chart, and insert a Column chart.Under Chart title in the Chart panel, type Sales by region.
The last order was filed under the wrong region. Change
A13from South to West, and watch the totals and the chart.
Remember
- Charts are for summaries. Total a long list into a small table first.
SUMIF(or a PivotTable) makes the small table; the chart draws it.- Data, summary and chart are linked: correct a row and all three agree.
In the function reference: SUMIF
Previous: Trendlines and forecasts · Next: Stacked columns: the parts and the total