• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Make a Graph in Excel

April 26, 2021 by Andrew Childress
make a graph in Excel

It’s often useful to visualize data with a simple graph. These are easy to draw inside spreadsheets. Here's how to make a graph in Excel.

It’s often useful to visualize data with a simple graph. Fortunately, these are easy to draw inside spreadsheets. Let’s learn how to make a graph in Microsoft Excel.

How to Make a Graph in Excel

Imagine a table showing a list of years, and annual revenues for those years. While you could simply show the data in the table, it might be easier to illustrate it with a graph. This helps viewers easily see year-over-year changes and growth.

To get started, click and drag to select the data inside the two columns. In this case, this is the range A1:B5. Then, with the data selected, go to the Insert tab on Excel’s ribbon. Near the middle, you’ll see a dropdown menu called Recommended Charts.

Graph in Excel

Go ahead and click here. This is the easiest way to insert a graph in Excel. It automatically analyzes your dataset, and sorts it into logical rows and columns that present well in a graph format.

Scroll through the available options. Excel will present several styles that best portray the data. At the top, you’ll see the classic line graph. Below are other options, such as bar graphs and scatter graphs, along with other layouts like pie charts.

make a graph in Excel

When you see the graph layout that you like best, click on the thumbnail in the drop-down menu. Excel will automatically insert the graph onto your spreadsheet.

How to make a graph in Excel

You’ll see that the years are on the horizontal axis, and revenue figures are on the vertical axis. Working in the Chart Design and Format tabs, you can easily make changes to the look and feel of your graph. For example, you can add a graph title, axis labels, change the color of the line, and more.

As you can see, it’s easy to insert simple graphs in Excel to illustrate your data in style.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Dollar sign in ExcelDollar Sign in Excel
Next Post:Histograms in ExcelHow to make a histogram in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top