How to Create Charts in Excel (Free Practice File)

To create charts in Excel, put your labels and numbers in a small table, select the data, and open Insert → Recommended Charts. Choose a chart that makes the comparison easy to understand. This guide uses a simple column chart to compare study time across five days.

You will build the chart, label it, change a value, and check that the result updates. The example uses fictional data and ordinary Excel features. Menu names can differ between Windows, Mac, and Excel for the web; the main steps stay the same.

Download the free Excel chart practice file

Download the Excel chart practice workbook (.xlsx). It contains one worksheet, five editable study-time values, an editable column chart, and formulas for the total and daily average. You can also build the example from a blank workbook using the steps below.

Excel worksheet with a column chart showing study minutes: Monday 30, Tuesday 45, Wednesday 25, Thursday 40, Friday 35.
The practice workbook compares five days of fictional study time. Its total is 175 minutes.

1. Prepare the data for your Excel chart

In the download, open the Chart practice worksheet. If you are starting from a blank workbook, enter this table in A5:B10. Row 5 contains the headings, and rows 6–10 contain the five days.

DayStudy minutes
Monday30
Tuesday45
Wednesday25
Thursday40
Friday35

Keep the day names in column A and the numbers in column B. Enter 30, rather than “30 minutes”, in the numeric cell. The heading supplies the unit. Use the same unit for every row, and keep empty spacer rows outside the selected table.

For this exercise, Tuesday should be the highest value at 45 minutes and Wednesday the lowest at 25 minutes. Those two checks will help you catch a wrong selection later.

2. Create a column chart in Excel

  • Select A5:B10, including both headings and all five data rows.
  • Open Insert → Recommended Charts.
  • Choose a 2-D Clustered Column chart. If it is not recommended, look under All Charts → Column. Some versions also offer column charts directly on the Insert tab.
  • Insert the chart and move it beside the table so both remain visible.

You should see five vertical columns, with Monday through Friday along the bottom. The heights should match the numbers in the table. Leave the Total minutes and Average per day rows out of the chart selection: they summarize the same data and would add misleading extra columns.

3. Add a clear title and readable labels

Change the chart title to Completed study minutes. Label the vertical value axis Minutes. On Windows, chart elements are available under Chart Design → Add Chart Element; other editions may show them in a chart formatting pane.

  • Use one color for this single series so the column heights carry the comparison.
  • Keep zero visible on the vertical axis. Cutting off the bottom of columns can exaggerate a small difference.
  • Keep the day labels readable. A simple 2-D chart is enough for this example.
  • A legend is optional here because the title and axis already identify the one series.

4. Change a value and check that the chart updates

In the practice file, change Tuesday in B7 from 45 to 60. Its column should become taller. The total should change from 175 to 190 minutes, and the daily average should change from 35 to 38 minutes. Change B7 back to 45 to restore the original example.

The total in B13 uses =SUM(B6:B10). The average in B14 uses =AVERAGE(B6:B10). These formulas summarize the five numeric cells; the chart reads those source cells directly. You do not need a formula merely to insert a chart.

For a second check, restore Tuesday to 45, then change Monday from 30 to 50. The total should become 195 minutes and the average 39 minutes. Restore Monday to 30 when you finish.

5. Fix common Excel chart problems

What you seeWhat to check
A day is missingCheck that the selected source includes every intended row. If you add Saturday below the table, extend the chart source to include it.
The total appears as another columnReselect only A5:B10. Keep summary rows outside the chart data.
The day names appear as separate seriesCheck the selected range and use Chart Design → Switch Row/Column when the orientation is wrong.
A value is missing or treated as textRe-enter it as a plain number in the source cell. Changing only the display format does not always convert stored text.
Editing a number does not change the pictureMake sure you are editing the original Excel chart and its source range. A copied screenshot is a static image.

If you expand the table, also update any total and average formulas to cover the extra rows. Extending the chart range alone does not extend every separate formula in the workbook.

Which Excel chart type should you choose?

  • Column chart: useful for comparing a small set of category values, as in this five-day example.
  • Line chart: useful when the main question is how values change over an ordered timeline. Keep the dates in order.
  • Horizontal bar chart: useful when category names are long and need more room.

Choose the chart around the question you want to answer. A chart comparing minutes should keep minutes as its unit; avoid mixing a count, a percentage, and a duration on one unexplained axis.

Continue practising

Try the same method with a small table of fictional spending, books read, or tasks completed. Name the units, keep the source data beside the chart, and check the tallest and shortest values before sharing it.

For another beginner exercise, follow Create a Weekly Study Planner in Excel or Build Your First Spreadsheet Budget.

Microsoft references

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top