Skip to content
Tutorials Center
My learning

Topics

Lesson 50 of 93 ยท Charts and Visualization

Creating Your First Chart

Lay out data for a chart, insert one in Excel, and learn the chart elements: title, axes, legend and data labels, with a runnable text-chart stand-in.

A table of numbers is accurate, but a chart is how people notice things: the month that dipped, the product that dominates, the trend that keeps climbing. Excel makes a first chart a matter of seconds. Making a good chart is mostly about preparing the data correctly and understanding the parts a chart is made of.

This lesson shows how to lay out the data, insert a chart and name each element. Excel and its charts cannot run on this site, so the steps are described in text. To see the idea working, a small JavaScript stand-in draws a text chart from the same kind of table. The stand-in shows how a chart is built from cells, not how Excel draws pixels.

From cells to chart

Layout Labels in one column, numbers beside them.
Select Include the headers.
Insert Pick a chart from the ribbon.
Polish Title, axes, legend, labels.

A chart stays linked to its cells.

1 / 2

Step 1: lay out the data

Excel reads a chart from a rectangle of cells. The reliable layout is a table with headers: the first column holds the categories and each further column is one data series.

TEXT
      A          B        C
1   Month      Sales    Costs
2   Jan         120       90
3   Feb         135       95
4   Mar         128      100
5   Apr         150      110

Here the months are the categories (they become the labels on the horizontal axis) and Sales and Costs are two series (each becomes a set of columns or a line, with its own color). Follow these rules and most charts work immediately:

  • Put a header in the first row of each series. Excel uses it as the series name in the legend.
  • Leave the top-left cell empty or give it a label; when the first column is text, Excel treats it as categories.
  • Keep the block free of blank rows and columns, and of totals rows that would become bars of their own. If your data is formatted as an Excel Table, the chart grows when you add rows.
  • Use real numbers. Numbers stored as text are left out of the plot (see Text Formatting and Conversion).
  • Dates in the first column make Excel build a date axis with evenly spaced time, which is usually what you want for a timeline.

A mistake beginners make is selecting a single column of numbers only. Without categories, the horizontal axis shows 1, 2, 3 instead of month names.

Step 2: insert the chart

  1. Click any cell inside the data (or select the range A1:C5).
  2. Go to the Insert tab. In Charts, choose a type such as Column, Line or Pie, then pick a sub-type.
  3. Or choose Recommended Charts. Excel looks at the shape of your data and proposes charts that fit; each one is shown with a preview using your numbers.
  4. For a very quick chart, select the data and press Alt + F1 to insert a default chart on the same sheet, or F11 for a chart on its own sheet.

When a chart is selected, two extra tabs appear: Chart Design (layouts, colors, styles, Switch Row/Column, Select Data, Move Chart) and Format (shapes, fills and text styles for the selected part). Three small buttons beside the chart's top-right corner open shortcuts: Chart Elements (+), Chart Styles (brush) and Chart Filters (funnel). Exact names and positions can change between Excel versions and between Windows, Mac and the web, so look for the icons if a label is missing.

Which type to pick is its own topic: see Choosing the Right Chart Type. For a first chart, a clustered column chart for comparing categories or a line chart for change over time is a safe start.

Step 3: know the elements

Click different parts of the chart and you will see that each one is a separate object that you can select, format or delete.

  • Chart area: the whole rectangle. Plot area: the part inside the axes where the data is drawn.
  • Chart title: a text box. By default it may read "Chart Title" or the series name. Replace it with a sentence that says what the reader should learn, for example "Sales grew every month except March". You can link it to a cell: select the title, type = in the formula bar and click the cell.
  • Axes: the category axis (horizontal in a column chart) and the value axis (vertical). The value axis has a scale: a minimum, a maximum and a step. Each axis can have its own title with units, such as "Thousands of USD".
  • Gridlines: faint lines that help the eye read values. Light horizontal lines are usually enough.
  • Legend: names the series and their colors. With a single series, delete it: it adds nothing.
  • Data labels: numbers printed on the bars or points. Use them when exact values matter, and skip them when there are dozens of points.
  • Series: the data behind one set of bars or one line. Each cell becomes one data point.

A mismatch between rows and columns is the usual surprise. If Excel plots months as separate series and products as categories, click Switch Row/Column on the Chart Design tab to swap them.

The chart is linked to the sheet

A chart does not hold copies of your numbers; it reads the cells every time. Change B3 from 135 to 180 and the matching bar grows immediately. Formulas feed charts as well, so a chart can show a SUM total or a dynamic array result.

Two consequences follow. First, hidden rows and columns are not plotted by default. To include them, open Select Data > Hidden and Empty Cells and tick Show data in hidden rows and columns. Second, empty cells are drawn as gaps by default, while #N/A makes a line chart skip a point without dropping to zero.

A chart can sit on the sheet next to its data (an embedded chart) or on a separate chart sheet that has nothing else. Embedded charts are better for dashboards and reports because they sit near the numbers. Use Move Chart to switch between the two.

Name a chart by selecting it and typing in the Name Box (left of the formula bar). Meaningful names such as SalesChart help when you have ten charts on a dashboard or write automation later.

Stand-in 1: a chart is a function of cells

The text chart below reads a table in the same shape as the one above and prints a title, the category labels, a legend and data labels. Change a number in the table, run again, and the bars change. It is our simplified model of how a chart reads cells, not Excel's rendering code.

JS Draw a text column chart from a table

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Stand-in 2: switch rows and columns, and see hidden data

Many "my chart looks wrong" questions come down to two facts: which direction Excel reads the series, and whether hidden rows are skipped. This stand-in models both.

JS Switch Row/Column and hidden rows

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Common mistakes

  • Including a totals row in the selection, which makes the total the tallest bar.
  • Leaving the default title such as "Chart Title". Always write a real one.
  • A legend for one series. Delete it and put the meaning in the title.
  • Too many series. More than four or five colors turn a chart into noise; split it into several charts.
  • Charting text numbers. If bars are missing, check the cells are numbers and not text.

Formatting details such as axis scales, colors and alt text come next, in Formatting and Improving Charts.

Check your understanding

Quick check ยท 5 questions

of 5 answered You scored / 5 ยท perfect!

  1. 1. In a table with Month in column A and Sales and Costs in columns B and C, what are Sales and Costs in chart terms?

    Each column of numbers with a header becomes a series. The months in column A are the categories on the axis.
  2. 2. What happens to a chart when you change a number in the cells it uses?

    Charts read their cells every time, so edits and formula results show up immediately.
  3. 3. Your chart plots months as separate series but you want them on the axis. What should you click?

    Switch Row/Column on the Chart Design tab swaps what Excel treats as series and categories.
  4. 4. Why is a chart missing the data from a hidden row?

    By default Excel ignores hidden rows and columns. You can change this in Select Data under Hidden and Empty Cells.
  5. 5. Which shortcut inserts a default chart for the selected data on the same sheet?

    Alt + F1 creates an embedded default chart. F11 creates a chart on a new chart sheet.

Summary

  • Lay data out as a table with headers: categories in the first column, one column per series, no blanks or totals.
  • Insert a chart from the Insert tab, with Recommended Charts, or press Alt + F1.
  • A chart is made of objects: title, axes, gridlines, legend, data labels and series. Each can be formatted separately.
  • Charts stay linked to cells; hidden rows are skipped unless you change the setting, and Switch Row/Column swaps series and categories.
  • Write a meaningful title and drop the legend when there is only one series.

Next: Choosing the Right Chart Type.