• 6 hours
  • Easy

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 9/1/22

Create Charts

Create charts
Create charts

If you want to get the most out of your data, you’ll probably need to create some charts. In Excel, these can be created very easily—and sometimes even automatically!

Create a Chart

To create a chart, you first need some data that you want to display. So, you have an Excel worksheet with some data you want to present more clearly.

We’ll start with this table:

Use a data table to create a chart in Excel
Use a data table to create a chart in Excel

Next, you’ll need to define:

  • the data you want to represent in the chart.

  • the type of chart you want to create. The main ones Excel has to offer are:

    • column (vertical) or bar (horizontal) charts.

    • line charts (very useful for showing changes over time).

    • scatter charts.

    • pie charts (to show proportional data). 

In our example, you want to create a chart to show the ups and downs of a set of sales figures from January to June. You might choose a line or column/bar chart. In both cases, you’ll have:

  • months on the x (horizontal) axis. 

  • sales figures on the y (vertical) axis.

Select the Data

You want to create a chart containing:

  • months (cells B3 to B9).

  • sales figures (cells D3 to D9).

Choose a Chart

  • Click on the Insert tab.

  • In the Charts tab, click on the Insert Column or Bar Chart icon.

  • In 2-D Column, select Clustered Column.

Excel has automatically created this chart:

Automatically generated column chart
Automatically generated column chart

You could also create a chart comparing the monthly sales figures for the previous year vs. the current year.

To do this:

  • Select the data (here, B3 to B9 and D3 to E9).

  • Insert a chart, e.g., a line chart. 

You’ll see the following chart:

Format the Chart

Give It a Title

Excel has created an automatic title for your chart using your column headings. If you’d like to change it:

  • Click on the title to select it.

  • Change the title.

  • Press Enter to confirm.

If Excel hasn’t provided it automatically, you can also insert a title:

  • Select the chart.

  • Click on the Chart Design tab.

  • In the Chart Layouts group, click on Add Chart Element.

  • Select Chart Title.

Specify the Legend, Data and Axis Titles

To specify the axis titles, you can choose Axis Titles from the Add Chart Element options.

Options on the Add Chart Element icon
Options on the Add Chart Element icon

You can also add a legend either to the side of the chart or directly on it.

In addition, you can label the data on the chart. For example, we might use the worksheet data to create a chart showing percentages:

Chart showing the data as percentages
Chart showing the data as percentages
Move the Chart

You might not want to show the chart on the data source worksheet you used to generate it. To do this:

  • Select the chart.

  • Click on the Chart Design tab.

  • In the Location group, click on the Move Chart icon.

  • Select the new location.

Watch the Video Tutorial

Watch a step-by-step recap of everything described in this chapter in the tutorial below:

Let’s Recap!

  • Charts are visual representations of the data you’re processing. They are refreshed whenever you change the data.

  • Column and bar charts enable you to compare sets of data.

  • Line charts enable you to represent a change over time.

  • Pie charts enable you to represent proportional data.

In this last part of the course, you’ve learned how to analyze data in Excel. In the next chapter, we are going to put what we’ve learned into practice!

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best
Example of certificate of achievement
Example of certificate of achievement