Create a simple chart and summary

Chart type should follow the analytical question

Microsoft provides chart creation tools and recommended charts based on selected data.

Microsoft notes that data arrangement affects which chart can be created and how categories and series are interpreted.

Use bars for category comparison, lines for ordered time trends and scatter plots for relationships between two numeric variables. Pie charts make precise comparison difficult and become cluttered with many categories. The title should state the measure and scope, not merely “Chart 1.”

Build a chart-ready summary

Do not chart a raw operational table if the question requires totals by category. Create a small summary area or PivotTable with one row per category or time period. Include units and confirm whether values are counts, percentages, averages or totals.

1. 1

   Write the question in one sentence.

2. 2

   Choose the measure and unit.

3. 3

   Define the category or time axis.

4. 4

   Create a summary table.

5. 5

   Check totals against the source.

6. 6

   Remove blank or subtotal rows from the chart range.

Create and label the chart

Select the summary table, insert the intended chart and inspect how Excel assigned series and category labels. Switch row and column only when it matches the question. Add a specific title, axis labels where needed and direct data labels only when they improve interpretation.

1. 1

   Select the summary range.

2. 2

   Insert a recommended or chosen chart.

3. 3

   Confirm categories and series.

4. 4

   Add a descriptive title.

5. 5

   Label units.

6. 6

   Remove unnecessary legend or gridlines.

7. 7

   Check the axis scale and category order.

Write an evidence-based summary

Begin with what the chart directly shows: the highest category, direction of change or approximate difference. Then state limitations such as missing periods, small sample or unadjusted values. Explanations for why the pattern exists require additional evidence and should be labeled as hypotheses.

Test dynamic behavior by changing one source value or adding a row. If the chart does not update, the source range may be fixed or the summary may need refresh. Record the data date in the title or caption for recurring reports.

1. 1

   Write one observation sentence.

2. 2

   Add one comparison with units.

3. 3

   State one limitation.

4. 4

   Separate any causal explanation as a hypothesis.

5. 5

   Change a test value and confirm chart update.

Test independent understanding

Show the chart without the surrounding worksheet and ask a reviewer what it measures, over what period and what conclusion is justified. If they cannot answer from the title, labels and caption, the chart depends too heavily on hidden context.

Common mistakes to avoid

• Selecting raw data with unrelated columns.
• Using a chart type that does not match the question.
• Truncating the axis to exaggerate differences.
• Writing causal explanations without evidence.