Learn Charts in Excel for Beginners

Excel charts are a great way to visualize data and make it easier to understand. They can be used in reports, presentations, and other documents to help you communicate your ideas more effectively.

This article will teach you how to create charts in Excel, even if you’re a beginner. We’ll cover the basics of chart types, how to select data for your chart, and how to customize your charts.

What are Charts?

A chart is a graphical representation of data. It can be used to show trends, patterns, and relationships in data. There are many different types of charts, each of which is best suited for a different type of data.

Excel chart insert

Types of Charts in Excel

The most common types of charts in Excel include:

Column chart

Column charts are used to show comparisons between different categories of data.

Column Chart Example

Line chart

Line charts are used to show trends over time.Example Line Chart

Pie chart

Pie charts are used to show the relative size of different parts of a whole.Excel Pie Chart Example

Bar chart

Bar charts are similar to column charts, but they are used to show comparisons between different categories of data that are not continuous.Bar Chart example

Area chart

Area charts are similar to line charts, but they show the cumulative total of the data over time.Area Chart Example

See also  Import Data from Access to Excel

Scatter chart

Scatter charts are used to show the relationship between two variables.Scatter Chart Tutorial

Stock chart

Stock charts are used to track the price of stocks over time.Stock Chart Excel

Surface chart

When you show two sets of data.

surface chart example

Doughnut chart

Similar to pie chart but can include few data series

Doughnut Chart Example

Bubble chart

It’s a kind of surface chart. Use it when you show three series of data. Bubble chart is often used for financial data to show difference between values.

ready bubble chart

Radar chart

A good way to display one or more variables for the two-dimensional diagram, wherein each arm presents another variable. The line connects all the data points from a spreadsheet along each arm.

radar chart example

That are basic charts which you can insert in Excel. There are many more types of charts. On this website you can find many lessons about charts in Excel. Not only basics.

How to Create a Chart in Excel

To create a chart in Excel, follow these steps:

  1. Select the data that you want to include in your chart.
  2. Click the Insert tab and then click the Chart button.
  3. Select the type of chart that you want to create.
  4. Excel will create a chart based on the data that you selected.
  5. You can customize your chart by changing the chart title, axis labels, and other elements.


Charts are a powerful tool that can be used to visualize data and make it easier to understand. By learning how to create charts in Excel, you can improve your ability to communicate your ideas effectively.

Things to remember

  • Use the right chart type for your data.
  • Select the right data for your chart.
  • Customize your chart to make it look professional.
  • Use charts to communicate your ideas effectively.