EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Types of Graphs
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Types of Graphs

By Madhuri ThakurMadhuri Thakur

types of graphs example

Excel Types of Graphs (Table of Contents)

  • Types of Graphs in Excel
  • How to Create Graphs in Excel

Types of Graphs in Excel

We have seen multiple uses of excel in our professional lives; it helps us analyze, sort and extract insights from data. There is one feature of excel that helps us put insights gained from our data into a visual form. This feature helps us display data in an easy to understand pictorial formats. We are talking about graphs in excel. Excel supports most of the commonly used graphs in statistics.

Creating different types of graphs in excel according to our data is very easy and convenient when it comes to analysis, comparing datasets, presentations etc. In this article, we will discuss the six most commonly used types of graphs in excel. We will also discuss how to select the correct graph type for some kinds of data.

Common Types of Graphs in Excel

The most common types of graphs used in Excel are:

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • Pie Graph
  • Column Graph
  • Line Graph
  • Area Graph
  • Scatter Graph

Let’s understand what the different types of graphs in Excel are and how to create them. We will start with a few examples of types of graphs in Excel.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,813 ratings)
You can download this Types of Graphs Excel Template here – Types of Graphs Excel Template

1. The Pie Graph

As the name suggests, the pie graph is a display of data in the form of a pie or circle. This graph type is used for showing proportions of a whole. For example, if we want to compare who did how much work in a team, we would use a pie graph to display it in an easy way to understand.

So our data looks like this:

types of graphs example 1-1

Would now look like this:

Types of graphs example 1-2

We can also use different types of pie graphs such as a 3D pie graph, pie of pie, bar of pie or a doughnut graph to represent the same data.

2. The Column or Bar Graph

The next one in the list is a column graph, also called a bar graph in statistics. We use these different types of graphs where we need to see and compare values across a range. The same data that we used in the pie graph example would look like this:

Types of graphs example 1-3

There are different types of bar graphs available in Excel, such as stacked columns, 100% stacked column, 3D columns etc. These types of graphs can be used for expanded datasets. For example, we have been working with only two columns in the last two examples, now; if we want to include the hours worked as a third column and compare the hours worked with the number of datasets visually, we can either use a stacked column or a 100% stacked column which would look like this:

Types of graphs example 1-4

The difference between these is that while a stacked column represents actual values, a 100% stacked column represents the values as percentages. There are 3D version as well as horizontal versions of these graphs in excel.

3. The Line Graph

The next type of graph we are going to discuss is called a line graph. This type of graph is used when we need to visualize data like an increasing or decreasing series over a period. This is an excellent graph in Excel to use for representing trends and comparing performance. For example, if we wanted to see how the current rise compares to the last raise for different people in the earlier examples, we would get something like this:

Types of graphs example 1-5

We can see that Rohit is the only one whose pay raise has increased while other’s pay raise percentages have remained constant over the last year. We have different line graphs or line graphs available for use in excel, such as stacked lines and 100% stacked lines.

Types of graphs example 1-6

Stacked lines like stacked columns are used to represent percentages instead of the actual values.

4. The Area Graph

The area graph is available within the line graph menu. This is used for the same purpose as the line graph, which visualises trends and compares data. In this example, we represent the relationship between the number of datasets worked on by an analyst and the number of hours they worked.

Types of graphs example 1-7

The stacked area graph on the right is used for drawing attention to the difference in magnitude of two categories and displays the values as percentages.

5. The Scatter Graph

The Scatter graph is a simple representation of data points in excel. It is used when we need to compare at least two sets of data with a limited number of data points.

Types of graphs example 1-8

There are many more types of graphs available in Excel, such as Hierarchy graph, Radar graph, Waterfall graph and Combo graphs which are combinations of two or more graphs. All these are used based on specific conditions fulfilled by the data, such as the type of data, the number of data points etc.

How to Create Graphs in Excel?

Now that we have gone through a few examples of types of graphs in excel, we will learn how to make these graphs. Basically, the same procedure is used to make all the graphs. They are enumerated sequentially below:

1. First, choose the data you want to represent in the graph. In this case, we will select Analyst and Datasets from the practice table:

Types of graphs example 2-1

2. Click on Insert on the toolbar and navigate to the Charts menu.

Charts Menu

3. Select the required graph from the different types of graphs; in this case, we are making a bar graph which is basically a horizontal column graph, but you can select any graph that suits the data you are working on:

Clustered Bar

4. A graph would appear over your data, move the graph to the required position by clicking on it and dragging it across the screen, or cut/copy the graph and paste it elsewhere where you need it:

Chart Title

By following the above steps and varying the type of graph you select, you can make all types of graphs available in excel. You can modify these different types of graphs like modifying a table, by specifying the data which would go into the x-axis and y-axis by right-clicking on the graph and clicking on select data, then specifying the data in the pop up that appears:

Data Source

Things to Remember About Types of  Graphs in Excel

  • Know your data before making a graph. A type of graph that may suit a time series may not be suitable for a set of unpatterned data.
  • Sort the data before making graphs.
  • Do not use unnecessary styling while making the graph.

Recommended Articles

This has been a guide to Types of Graphs in excel. Here we discussed Different types of Graphs in excel and how to create these different types of Graphs in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Gauge Chart in Excel
  2. Excel Normal Distribution Graph
  3. Change Chart Style In Excel
  4. Excel Chart Templates
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Types of Graphs Excel Template

EDUCBA

Download Types of Graphs Excel Template

EDUCBA

डाउनलोड Types of Graphs Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more