Make Your First Excel Chart: Choose a Clear Story and Check the Numbers
On this page
A useful chart helps someone answer a question faster than they could by reading a table. Your first Excel chart should start with that question, not with colours or effects. We will build a simple monthly sales chart and check that it tells the same story as the source data.
Before you start: Use a new practice workbook. The names and figures below are fictional. Enter the headers in row 1 and the first record in row 2 unless a step says otherwise. Formulas use English function names and commas; your regional settings may require semicolons instead. Save a copy before experimenting.
Enter the source data
Use A1:B7 for this fictional six-month record. Each amount is in currency units, not thousands or percentages. Keep the months in calendar order.
| Month | Sales |
|---|---|
| January | 1200 |
| February | 1500 |
| March | 1300 |
| April | 1800 |
| May | 1700 |
| June | 2100 |
Our question is “How did monthly sales change from January through June?” This is a time sequence. A line chart shows the progression clearly, while a column chart can emphasise comparisons between the individual months. Either can work when labelled honestly.
Insert a simple chart
Select A1:B7, then use Insert to choose a basic line chart with markers or a clustered column chart. Avoid a three-dimensional style. Extra perspective makes values harder to compare without adding information about the sales.
Check that the horizontal axis contains January through June and that there is one series named Sales. If months appear as separate series or the chart is empty, inspect the source range and orientation before changing the formatting.
Use the title Monthly sales, January to June. Add a vertical-axis label such as Sales (currency units). A title should say what was measured and over what period. A generic title such as Chart 1 forces the reader to guess.
Match the visual to the numbers
June should be highest at 2100. January should be lowest at 1200. February rises from January, March dips, April rises, May dips slightly and June rises again. If your chart shows a smooth increase every month, something is wrong with the input range or order.
Check several points against the worksheet rather than trusting the default preview. If you add data labels, use them sparingly. Six labels may be manageable; hundreds can make a chart unreadable. The underlying table should remain available for exact values.
Use a fair axis scale
For a column chart, start the value axis at zero so the lengths of the columns reflect the amounts fairly. Cutting the axis to start near 1200 can exaggerate the apparent difference between months.
A line chart can sometimes use a narrower axis to show changes, but the scale needs to be obvious and appropriate for the question. Do not let an automatic scale imply a dramatic change without checking it. A chart's appearance is a choice that affects interpretation.
Avoid a pie chart for this time trend. A pie shows parts of a whole, not the sequence of monthly rises and dips. It would make it harder to follow the change from one month to the next.
Add a short, accurate explanation
The total is =SUM(B2:B7), which returns 9600. June is 900 higher than January. The relative increase is =(B7-B2)/B2, which gives 75% when formatted as a percentage.
That comparison does not prove what caused the rise. A promotion, a price change or a seasonal pattern would need additional evidence. Keep observations separate from explanations. “June sales were 75% above January” is supported by this table; “the new campaign caused the increase” is not.
Make the chart readable at a small size
Use a clear font, enough contrast and a restrained colour scheme. Do not rely on colour alone to distinguish series when a chart has more than one. Keep the title short and avoid squeezing long labels into a narrow space.
Resize the chart to roughly the size you plan to share and read it again. If the labels are too small or overlap, simplify the design. A chart that only works when stretched across your full screen may not work in a phone screenshot or a small report panel.
Try it yourself
Add July with sales of 1900. Extend the chart source if it does not expand automatically. What should the new total be, and what should the line or final column show relative to June?
Check your answer
The new total is 11500. July should be lower than June by 200, but higher than May's 1700. The chart must include a July category and its 1900 value.
If the total changes but the chart still ends at June, its source range has not expanded. Check the chart's selected data range or use an Excel Table as the source so future additions are easier to maintain.
Keep learning: Return to the Excel learning path to choose your next lesson.