Types of Charts in Excel

Article byWallstreetmojo Team
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

What Are Charts In Excel?

Charts in Excel are used to represent the data inserted in the worksheet. It is used to graphically show the data and aid to help users understand the data.

For example, consider the below example showing marks obtained by students in 2 semesters.

Types of Charts Intro

Now, we can represent the data using line chart in Excel.

Step 1: Select the cell range which we want to represent the data in line chart.

Step 2: Select Insert > Charts from the charts group.

We can see the data converted into a chart immediately.

Likewise, we can readily convert data into charts in Excel.

Types of Charts Intro Graph

Key Takeaways

  • Charts in Excel are used to represent the data graphically.
  • If we copy a chart from one location to another, the data source will remain the same. However, it means that if we make any changes to the data set, both the charts will change, the primary and the copied.
  • For the stock chart, there must be at least two data sets.
  • We can only use a pie chart to represent one series of data. They cannot handle two data series.

List Of Top 8 Types Of Charts In MS Excel (With Steps And Examples)

  1. Column Charts in Excel
  2. Line Chart in Excel
  3. Pie Chart in Excel
  4. Bar Chart in ExcelBar Chart In ExcelBar charts in excel are helpful in the representation of the single data on the horizontal bar, with categories displayed on the Y-axis and values on the X-axis. To create a bar chart, we need at least two independent and dependent variables.read more
  5. Area Chart in ExcelArea Chart In ExcelThe area chart in Excel is a line chart that shows the impact and changes in various data series over time by separating them with lines and presenting them in different colors. The line chart is used to create this graph.read more
  6. Scatter Chart in Excel
  7. Stock Chart in ExcelStock Chart In ExcelStock chart in excel is also known as high low close chart in excel because it used to represent the conditions of data in markets such as stocks, the data is the changes in the prices of the stocks, we can insert it from insert tab and also there are actually four types of stock charts, high low close is the most used one as it has three series of price high end and low, we can use up to six series of prices in stock charts.read more
  8. Radar Chart in Excel

Let us discuss each of them in detail: –

You can download this Types of Charts Excel Template here – Types of Charts Excel Template

Chart #1 – Column Chart

In this type of chart, the data is plotted in columns. Therefore, it is called a column chartColumn ChartColumn chart is used to represent data in vertical columns. The height of the column represents the value for the specific data series in a chart, the column chart represents the comparison in the form of column from left to right.read more.

A column chart is a bar-shaped chart that has a bar placed on the X-axis. Such charts are very useful in case we want to make a comparison.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Below are the steps for preparing a column chart in Excel:

  1. First, select the data and the “Insert” tab, then select the “Column” chart.


    Column Chart Example 1

  2. Then, the column chart looks like as given below:


    Column Chart Example 1-1

Chart #2 – Line Chart

Line charts show the trend in data. They are used in analysis rather than showing data visually.

In this chart, a line represents the data movement from one point to another.

  • Select the data and “Insert” tab, then select the “Line” chart.
Line Chart Example 2
  • Then, the line chart looks like as given below:
Line Chart Example 2-1

Chart #3 – Pie Chart

A pie chart is a circle-shaped chart capable of representing only one series of data. A pie chart has various variants that are 3-D charts and doughnut charts.

A circle-shaped chart divides itself into various portions to show the quantitative value.

  • Select the data, go to the “Insert” tab, and select the “Pie” chart.
Pie Chart Example 1
  • Then, the pie chart looks like as given below:
Pie Chart Example 1-1

Chart #4 – Bar Chart

In the bar chart, the data is plotted on the Y-axis. Compared to the column chart, these charts use the Y-axis as the primary axis.

This chart is plotted in rows. That is why this is called a row chart.

  • Select the data, go to the “Insert” tab, and then select the “Bar” chart.
Bar chart example 4
  • Then, the bar chart looks like as given below:
Bar chart example 4-1

Chart #5 – Area Chart

The area chart and the line charts are the same, but the difference that makes a line chart an area chart is that the space between the axis and the plotted value is colored and is not blank.

Using the stacked area chart, this becomes difficult to understand the data as space is colored with the same color for the magnitude that is the same for various datasets.

  • Select the data, go to the “Insert” tab, and select the “Area” chart.
Area Chart Example 1
  • Then, the area chart looks like as given below:
Type #8 - Area Chart in Excel

Chart #6 – Scatter Chart

The scatter chart in excelScatter Chart In ExcelScatter plot in excel is a two dimensional type of chart to represent data, it has various names such XY chart or Scatter diagram in excel, in this chart we have two sets of data on X and Y axis who are co-related to each other, this chart is mostly used in co-relation studies and regression studies of data.read more plots the data on the coordinates.

  • Select the Data and go to Insert Tab, then select the Scatter Chart.
Scatter Chart Example 5
  • Then, the scatter chart looks like as given below:
Type #8 - Scatter Chart in Excel

Chart #7 – Stock Chart

Such charts are used in stock exchangesStock ExchangesStock exchange refers to a market that facilitates the buying and selling of listed securities such as public company stocks, exchange-traded funds, debt instruments, options, etc., as per the standard regulations and guidelines—for instance, NYSE and NASDAQ.read more or to represent the change in the price of shares..

  • Select the data, go to the “Insert” tab, and then select the “Stock” chart.
Stock Chart Example 1
  • Then, the stock chart looks like as given below:
Type #8 - Stock Chart in Excel

Chart #8 – Radar Chart

The radar chartRadar ChartRadar chart in excel is also known as the spider chart in excel or Web or polar chart in excel, it is used to demonstrate data in two dimensional for two or more than two data series, the axes start on the same point in radar chart, this chart is used to do comparison between more than one or two variables, there are three different types of radar charts available to use in excel.read more is similar to the spider web, often called a web chat.

  • Select the data and go to “Insert Tab.” Then, under the “Stock” chart, select the “Radar” chart.
Type #8 - Radar Chart in Excel
  • Then, the radar chart looks like as given below:
Radar Chart Example 1-1

Important Things To Note

  • To keep the chart easy to understand, we should restrict the data series to two or three. Else, the chart will not be understandable.
  • We must add data labels if we have decimals values to represent.
  • If we do not add them, then we cannot understand the chart with accurate precision.

Frequently Asked Questions

1. What are charts in Excel?

Charts in Excel graphically represent the data. It aids in visual appeal and understand our data with ease.
The most common charts used in Excel are
Pie chart
Column chart
Line chart

2. How many types of charts are there in Excel?

There are 8 types of charts in Excel. They are:
1. Column Charts in Excel
2. Line Chart in Excel
3. Pie Chart in Excel
4. Bar Chart in Excel
5. Area Chart in Excel
6. Scatter Chart in Excel
7. Stock Chart in Excel
8. Radar Chart in Excel

3. How is column chart in excel used?

For example, consider the below example showing products and sales in 3 quarters – Q1, Q2 and Q3.

Types of Charts - FAQ 3

Now, we can represent the data using column chart in Excel.

Step 1: Select the cell range which we want to represent the data in line chart.

Step 2: Select Insert > Charts from the charts group.

We can see the data converted into a chart immediately.

Types of Charts - FAQ 3 - Graph

Likewise, we can readily convert data into charts in Excel.

This article is a guide to Types of Charts in Excel. Here, we discuss the top 8 types of graphs in Excel, including column charts, line charts, scatter charts, radar charts, etc., along with practical examples and a downloadable Excel template. You may learn more about Excel from the following articles: –

Reader Interactions

Leave a Reply

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