We can help you develop your capabilities until you achieve your dream

Digital marketing

How to Make and Plot Graphs in Excel: [2025 Tutorial]

How to Make a Graph in Excel in 11 Steps

1. First, input the data into Excel.

2. Go to the ‘Insert’ tab and choose a graph type.

3. Select the data you want to use.

4. Click ‘Insert’ to add your chosen graph.

5. Adjust which data appears on each axis if necessary.

6. Change the chart’s layout and colors.

7. Resize the chart’s legend and axis labels as needed.

8. Modify the Y-axis measurement options if required.

9. Reorder your data if it improves clarity.

10. Add a clear title to your graph.

11. Save or export your graph for use in reports or presentations.

Microsoft Excel is a very useful data management tool used widely by almost every organization today to analyze and interpret data. A Graph in Excel is a design tool that helps us visualize data. Excel has a variety of graphs and charts that can be used to represent data in different ways. This article will help you understand the different types of graphs available in Excel, and learn how to make a graph in Excel.

What is a Graph in Excel? 

In simple terms, a graph is a visual element that represents data in a worksheet. You will be able to analyze the data more efficiently by looking at a graph in Excel rather than numbers in a dataset. Excel covers a wide range of graphs that you can use to represent your data. Creating a graph in Excel is easy. The graph below depicts the sum of active COVID cases that are grouped by WHO region.

intro_graph_GraphInExcel

Looking at a graph helps us analyze various metrics just by taking a glance at it.

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program

Become a Data Scientist with Hands-on Training!

Reasons to Use Graph in Excel

Graphs in Excel simplify complex data, making it easier to understand at a glance. Instead of navigating through numbers, a graph visually highlights key trends and comparisons. Learning how to create a chart in Excel or how to create graphs from Excel data can help convey your message clearly and ensure your audience quickly grasps essential insights. Next, let us learn types of graphs and how to make a graph in excel.

Types of Graphs in Excel

Excel has most of the common graphs that are used for statistics. The types of graphs in Excel include:

1. Bar/Column Graphs

A bar graph shows information about two or more groups. Bar graphs are mainly used to make comparisons across a range. 

Type_barGraph

2. Pie Graphs

A pie chart is nothing but a circular graph representing data in the form of a pie/circle. It is divided into different sections, each one representing a proportion of the whole.  

Type_PieChart_Graph

3. Line Graphs

A line graph is formed by connecting a series of values/data points using straight lines. A line graph can be used when you want to check whether the values are increasing or decreasing over some time. 

Type_lineGraph_Graph

4. Scatter Plot

A scatter plot, also called a coordinate graph, uses dots to represent the data values for two different variables, one on each axis. This graph is used to find a pattern/ relationship between two sets of data.

Type_scatterPlot_GraphInExcel

5. Area Chart

An area chart depicts the change of two or more data points over time. They are similar to the line charts, except the area charts are filled with color below the line. This chart is useful to visualize the area of various series relative to each other.

Type_areaGraph_GraphInExcel

Before you make a graph in Excel, it is important to first cleanse your data. The next section will cover a few Data Cleaning techniques.

6. The New and Improved Bar Graph (Now Called a Clustered Bar Graph)

A clustered bar graph in Excel displays data horizontally, making it simple to compare different series side by side. This chart is great for seeing the differences between categories. For example, you can use a clustered bar graph to compare sales figures for different products across several stores. By doing this, you can quickly spot which products are performing better in different locations, helping you make informed decisions about inventory and sales strategies.

7. Ditto for Column Charts (Renamed Clustered Column Charts) Clustered column

Clustered column charts show data vertically with each column representing a different data series. This type of chart is perfect for comparing items and seeing their rankings. For example, if you want to compare the performance of different sales teams across various states, a clustered column chart can clearly show which team is leading in each state. The taller columns make it easy to see which teams are performing best and which may need more support.

8. Radar Chart

Radar charts are used to compare multiple variables on a single chart, using a shape that connects various points. Each point represents a different variable, and the shape formed helps you see patterns and strengths. For example, you might use a radar chart to compare different candidates’ skills across areas like leadership, communication, and problem-solving. This helps you see where each candidate excels and where they might need improvement.

9. Funnel Chart

Funnel charts are useful for visualizing how data moves through different stages of a process. The wide end represents the starting point, and the funnel narrows as it progresses. This chart is great for analyzing processes like sales pipelines. For example, a funnel chart can show how many leads move from initial contact to final sale, highlighting where the biggest drop-offs occur and helping you focus on improving those stages.

10. Histogram Chart

Histograms display data by grouping it into ranges and showing how frequently values fall into each range. This type of chart is useful for understanding distributions. For example, if you want to analyze the age range of your customers, a histogram can show how many customers fall into each age group. This helps you identify trends, such as a shift in the age demographics of your target audience.

11. Box and Whisker Chart

A box and whisker chart, or boxplot, summarizes data by showing its distribution and any outliers. It includes a box that represents the middle 50% of the data, with lines extending to show the range. This chart is useful for comparing different data sets. For instance, you could use a box and whisker chart to compare test scores across different schools, revealing variations in performance and highlighting any unusual results.

12. Pareto Chart

Pareto charts use both bars and a line to show the frequency of issues and their cumulative impact. This helps you identify which problems to tackle first for the most significant improvement. For example, if you’re analyzing customer complaints, a Pareto chart can show which issues are the most common and have the biggest impact, helping you prioritize your efforts to resolve them.

13. Surface Chart

Surface charts offer a three-dimensional view of data, showing how different variables interact. This type of chart helps identify optimal combinations of factors. For example, you could use a surface chart to analyze how varying price and advertising spend affect sales, revealing the best conditions for maximizing revenue.

14. Sunburst Chart

Sunburst charts are used to visualize hierarchical data with concentric rings. Each ring represents a level of the hierarchy, making it easy to see relationships and structure. For example, a sunburst chart can show the breakdown of a company’s departments and sub-departments, helping you understand how different parts of the organization fit together.

15. Treemap Chart

Treemap charts display hierarchical data using nested rectangles, where the size and color of each rectangle represent different values. This chart helps visualize complex data structures in an organized manner. For example, a treemap can show revenue contributions from various business units, with each rectangle’s size reflecting revenue and color indicating performance levels.

16. Stock Chart

Stock charts are designed to handle financial data, such as stock prices over time. They often include features like zooming and scrolling for detailed analysis. For instance, a stock chart can show daily price movements and trading volumes, helping investors track market trends and make informed investment decisions.

17. Waterfall Chart

Waterfall charts illustrate how sequential positive and negative values impact a total value. This chart is useful for understanding the cumulative effect of various factors. For example, you could use a waterfall chart to track monthly revenue changes, showing how different elements like new sales and refunds contribute to the final revenue figure.

18. Filled Map Chart

Filled map charts visualize data on a map by coloring different regions based on data values. This chart is useful for seeing how data varies geographically. For example, a filled map can show sales performance by region, with different colors indicating varying levels of sales, helping you identify regional trends and make strategic decisions.

19. Combo Chart

Combo charts combine two or more chart types, such as columns and lines, to provide a comprehensive view of data. This allows for more detailed analysis. For instance, a combo chart might show sales figures as columns and profit margins as a line, offering a complete picture of financial performance and helping answer complex data questions. 

Let’s now focus on how to make a graph in excel. 

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program

Become a Data Scientist with Hands-on Training!

Data Cleaning

Data cleaning is the most crucial step to eliminate incomplete and inconsistent data. 

Remove Duplicate Values

You need to make sure your data is organized and free from duplicates. Duplicate values strongly affect the data that you are working on while creating graphs. Hence, it is essential to eliminate duplicate data by clicking on the Remove Duplicates option available on the Data Tab.

remove_duplicates_command

Use Find and Replace Tool to Clean Data

When it comes to Data Cleansing, find and replace is a great tool. Using this, you can find all the zeros and remove them. You can also replace all the formula references. 

Remove Extra Spaces

You can get rid of unwanted spaces between words or numbers which aren’t visible using the TRIM function. The syntax is:

=TRIM(text)

This function takes input as text and eliminates extra spaces. This results in no leading and trailing spaces, and only one space between the words. 

How to Make a Graph in Excel

  • You must select the data for which a chart is to be created.
  • In the INSERT menu, select Recommended Charts.
  • Choose any chart from the list of charts Excel recommends for your data on the Recommended Charts tab, and click it to preview how it will look with your data.
  • Please click on All Charts if you are unable to locate a chart you like.
  • Click on the chart that you prefer and then click OK.
  • You can add chart elements such as axis titles or data labels, customize the appearance of the chart, or change the data displayed in the chart by clicking on Chart Elements, Chart Styles, and Chart Filters in the upper-right corner of the chart.
  • Click on the chart TOOLS tab on the ribbon to add additional design and formatting capabilities and then click the options you desire under the DESIGN and FORMAT tabs.

Creating a graph in Excel is easy. This step-by-step tutorial will show you how to make a graph in Excel. The demo helps you create:

  • Bar Graph
  • Pie Chart
  • Scatter Plot

NOTE: The dataset we will use comprises the data on Coronavirus cases, country-wise. It has records of: 

  • WHO Region of every country. 
  • Confirmed cases
  • Active cases
  • Recovered cases
  • Deaths

You can download the above dataset using this link. Take a look at a summary of the dataset below. 

covid_dataset_1

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program

Become a Data Scientist with Hands-on Training!

Let’s move on to understand how to create a bar graph in an easy and simple way. 

1. Bar Graph

A bar graph helps you display data using rectangular bars, where the length of each bar is a numeric value depending on the category it belongs to.

Follow the steps listed below to know how to create a bar graph in Excel.

  • Import the data: There are numerous other ways to import data into your Excel workbook, depending on your file format. To do this, locate the Data tab → Get & Transform Data section → Get Data option and click on it. On clicking, a list of various options will appear, to import data from different sources. You can copy and paste this data into your workbook as well. 
  • When you choose to work on a specific set of data within the dataset in discussion, you can use the Filter option. This option filters the data based on the requirements you’ve selected. Inorder to do this, select the whole dataset, locate the Data tab and click on the Filter option. 

filter_1

  • Once you click on the Filter option, a downward-pointing arrow appears on the column headers of the particular dataset. You will need to click on the arrow to reveal options to select the required data.

asia_filter_2_DashboardInExcel

  • In this case, let’s filter the data according to a particular WHO Region. 
  • You can do so by selecting the Filter option that appears on the column header – WHO Region.
  • You will be able to locate a drop-down box with various filters. These can be added to the data.
  • The filters can be applied on multiple parameters and sorted in ascending or descending order. 

asia_filter

  • Here, select the South-East Asia region, and by clicking OK, you will be able to view data from the South-East Asian regions alone.

/covid_dataset_GraphInExcel

  • Once data that is required is ready, a bar graph can now be created. As shown you locate the INSERT TAB → Charts section → Bar Graph option and select the type of bar graph that best suits your requirement.

chart_options

  • After selecting the appropriate bar chart, you can see a blank window that is open on the Excel sheet. On right-clicking on this blank window, you should find an option to Select Data. Clicking on it will open the Select Data Source window on your screen.
  • Here, the chart data range can be added by simply dragging the mouse and selecting the required data.
    • Now, select the Legend entries (or Vertical axis). In the current example, we would select the Y-axis values as confirmed cases, recovered cases, deaths, and active cases. 
    • On the other hand, as for the horizontal axis, select all the countries that we have filtered in the current example from the WHO region, i.e., South-East Asia. 

data_source.

  • After specifying the appropriate values, click on OK. Excel will now display a graph on your worksheet. You can go ahead and format your graph based on your requirement. 

asia_graph

  • To make your charts attractive and aesthetically appealing, you may change the color palette of the graph, add text or display more information about it, etc. 
    • Double click on the chart window to locate various customization options in the toolbar, available to you.
    • You may also arrive here by selecting the option beside the chart. 
    • This will open a drop-down box consisting of various Chart Elements.

For this example, do select the Legend checkbox for displaying the confirmed cases, recovered cases, active cases, and deaths on the graph. Further, the Chart Title box can be selected to add a title.  

format_chart_DashboardInExcel

This was all about creating a bar graph in Excel. Let’s move ahead and learn how to create a pie chart. 

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program

Become a Data Scientist with Hands-on Training!

2. Pie Chart

A pie chart is a circular graph that represents data by dividing the circle into sectors, where each sector illustrates a proportion to the whole.

Follow the steps mention below to learn to create a pie chart in Excel.

  • From your dashboard sheet, select the range of data for which you want to create a pie chart. We will create a pie chart based on the number of confirmed cases, deaths, recovered, and active cases in India in this example.

/pieChart_data

  • Select the data range. Then, click on the Insert Tab. You will find the PIE chart option available in the charts group.

pieChart_optionGraphInExcel

  • Select an appropriate pie chart from a range of pie charts available. Clicking on it will open the PIE chart in a window. Right-click on the chart window and click on Select Data. The Select Data Source window will be opened where you can choose what data you want to be displayed on your pie chart.
  • Here, the chart data range can be added by simply hovering your mouse to select the data required. 
  1. You can now select the legend entries (or vertical axis). In this current example, you will need to select India to display the cases pertaining to a specific country.
  2. For labels on the horizontal axis labels, you may select confirmed cases, deaths, recovered, and active cases, and depict them on the chart. 
  3. After specifying the entries, click on OK. This will display the pie chart on your window. 

pieChart_dataSource

  • You can click on the icons next to the chart to add your finishing touches to it. Clicking on the chart elements will show you options where you can choose to display or hide data labels, chart tiles, and legend. You can choose from various styles by clicking on the chart styles. This lets you style your chart based on your requirement. You can also add multiple colors in your graph to make it look more presentable.
  • You can also format the data by clicking on the Format data labels. This will show you different label options from which you can check and uncheck the different options available under it. 

pie_chart_GraphInExcel

In the next section, you will learn how to create a Scatter Plot in Excel. 

3. Scatter Plot

A Scatter Plot consists of a horizontal axis, a vertical axis, and a series of dots where each dot represents data values.  

To demonstrate this, we use a Day-wise COVID dataset that has the columns:

  • Date
  • Confirmed Cases
  • Deaths
  • Recovered Cases
  • Active Cases

scatterPlot_data

Follow the steps below to understand how to create a Scatter Plot in Excel.

  • Select the required data. In this example, we depict the relation between date and confirmed cases using a Scatter Plot. So, we select only the columns containing the date and confirmed Cases. 

scatterPlot_selectedData.

  • Go to Insert Tab → Charts Section → Scatter Plot Option.

scatterPlot_option

  • Click on the appropriate Scatter Plot option. This will plot the values. You can format the chart, select a chart title, and add axis labels too. As you can notice, we have created a scatter plot on Date vs. Confirmed Cases.  From the figure, we can easily conclude how the confirmed cases of COVID rise drastically every day. 

/scatterPlot_graph_GraphInExcel

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program

Become a Data Scientist with Hands-on Training!

4. Histogram

A Histogram is a frequency distribution graph that uses rectangles/bars to group data into ranges and indicates the frequency of occurrence for each range.

To understand how histograms work, let’s look at an example.

The following Employee Salary dataset contains the columns:

  • Employee ID
  • Employee Name
  • Job Title
  • Total Pay

We will demonstrate how to create a histogram that depicts the number of employees under each salary group.

histogram_dataset.

We will demonstrate how to create a histogram that depicts the number of employees under each salary group.

Follow the steps mentioned below to create a simple histogram.

  • Select the data from the sheet on which you want to make a histogram.
  • Click on the Insert Tab, you will find the Insert Statistic Chart option in the Charts group.
  • A drop down will appear from where you can select the desired histogram chart.

insert_histogram_GraphInExcel

  • The histogram chart gets displayed. To customize your histogram, click on the icons that appear next to it.
  • Clicking on the chart elements will show you options where you can choose to display or hide axis titles, data labels, chart tiles, and Legend, etc.
  • Clicking on the chart styles lets you style your chart to your requirement. You can add multiple colors in your graph to make it look more presentable.

histogram_1

  • To format your histogram plot, double click on the graph. You will see the Format Axis window open on the right side.
  • Click on Axis options → Horizontal Axis. 

histogram_formatAxis

  • You will find a list of different options to modify your histogram chart. 
  • By Category: You can select this option if you have repeated lists of categories and if you want to know the sum or count based on those categories. 
  • Automatic: This is the default option. It automatically decides what bins to create in the histogram. As you can notice, 5 bins are created in our chart.
  • Bin Width: This option defines the range width. 

In this example, we have specified the bin width as 40000. 

  • Number of Bins: In this option, you can enter the number of required bins. The chart will be created with the specified number of bins.
  • Overflow Bin: This can be used when you want all the values over a certain value to be grouped together in the histogram. 

We have specified 300000 as our overflow value. Any value higher than 300000 will be grouped under the last range.

  • Underflow Bin: This can be used when you want all the values below a certain value to be grouped together in the histogram. 

We have specified 80000 as our overflow value. Any value lower than 80000 will be grouped under the last range.

histogram_formatAxis_2

  • Right-click on the chart and click on Add Data Labels to include the values on top of each range. 

/addDataLabels

  • After formatting the histogram accordingly, we arrived at the following graph.  

final_histogram_GraphInExcel.

This histogram successfully depicts the total number of employees grouped by salary range.  

This is all you need to know about how to make a graph in Excel.

Choose the Right Course

Simplilearn’s Data Science courses provide a comprehensive understanding of key data science concepts, tools, and techniques. With industry-recognized certification, hands-on projects, and expert-led training, our courses help learners gain the skills needed to succeed in the data-driven world. Upgrade your career with Simplilearn today!

Program Name

Post Graduate Program In Data Science

Professional Certificate Course In Data Science

DS Master’s

Geo Non US Program IN All Geos
University Caltech IIT Kanpur Simplilearn
Course Duration 11 Months 11 Months 11 Months
Coding Experience Required No Yes Basic
Skills You Will Learn 8+ skills including
Supervised & Unsupervised Learning
Deep Learning
Data Visualization, and more
8+ skills including
NLP, Data Visualization, Model Building, and more
10+ skills including data structure, data manipulation, NumPy, Scikit-Learn, Tableau and more
Additional Benefits Upto 14 CEU Credits Caltech CTME Circle Membership Live masterclasses from IIT Kanpur faculty and certificate from E&ICT Academy, IIT Kanpur Applied Learning via Capstone and 25+ Data Science Projects
Cost $$$$ $$$ $$
Explore Program Explore Program Explore Program

Conclusion

Graphs make it easier to analyze trends and patterns in data. We hope this article has helped you provide a basic introduction to the types of graphs available and how to make a graph in Excel. Improve your Excel skills by enrolling in the Post Graduate Program In Data Science offered by Simplilearn.

FAQs

1. How do I create a chart with multiple data in Excel?

To learn how to create a chart in Excel with multiple data series, first select the range of data you want to include. Then, navigate to the Insert tab and pick a chart type from the Charts group. Excel will generate a chart that displays all your selected data series. Adjust titles, colors, and styles as needed to effectively showcase your data, giving you insight into how to create graphs from Excel data.

2. How do I insert a chart in Excel?

Inserting a chart in Excel is simple. First, select the data you want to visualize. Next, go to the “Insert” tab and click on “Recommended Charts”. You’ll see a list of chart types that Excel suggests based on your data. Choose one that fits your needs, and Excel will insert the chart into your worksheet. You can then customize it to better suit your preferences.

3. Can I combine two charts in Excel?

Yes, you can combine two charts in Excel. If both charts are of the same type, like two bar charts, you can copy one and paste it into the other. Excel will merge them into a single chart. For different types of charts, consider using a combo chart or manually adjusting the data series to integrate them effectively.

4. How can I customize the title of my Excel graph?

Customizing the title of your Excel graph is easy. Click on the chart to select it, then go to the “Chart Design” tab. Click on “Add Chart Element”, choose “Chart Title”, and select your preferred title option. You can then type your desired title directly into the Chart Title box and format it to match your chart’s style.

5. How do I add data labels to my Excel graph?

To add data labels to your Excel graph, click on the chart to select it. Then, go to the “Chart Design” tab and click “Add Chart Element”. Select “Data Labels” and choose where you want them to appear on the chart. The data labels will show up next to each data point, helping you highlight specific values and make your chart more informative.


Source link

اترك تعليقاً

لن يتم نشر عنوان بريدك الإلكتروني. الحقول الإلزامية مشار إليها بـ *

زر الذهاب إلى الأعلى

Please turn off the ad blocker, as ads are the only source of our continuity

برجاء دعمنا عن طريق تعطيل إضافة Adblock