Make a Graph in Excel

How to Make a Graph in Microsoft Excel - 2019 Guide

May. 24, 2017 10:32 am / Posted by Michael Eric to Office Tricks
Follow @MichaelEric

Making graphs and charts is the common and basic requirement for working people. Nowadays, most of the office workers use Microsoft Excel to make charts. Since the latest Excel version is Excel 2016, in this tutorial, we shall show you how to make a graph in Excel 2016/2013/2010/2007/2003 in the year of 2017.

make graph

What kind of Graph types in Excel File?

When you open an Excel document, there are 3 kinds of graph types mainly, which are:

Line Graphs: Line Graphs do well in displaying tendency over time, such as average number of hours worked in a week and product trends by month. Either 2-dimension or 3-dimension line graph is effective in Microsoft Excel.

make graph

Column Graphs: Column Graphs also help the observers to see how the parameters vary as time goes on. However, they are able to be named “graphs” only if a single data parameter is used. Once the diversified parameters are joined in, readers couldn’t gain any discernments about how each single parameter has turned.

make graph

Bar Graphs: Bar Graphs are quite analogous to column graphs, but its constant parameter is allocated to the Y axis and variables are in the X axis.

bar graphs

How to Make a Graph in Excel Spreadsheet?

To create a graph in Microsoft Excel document, you will need to do the following steps.

Step 1. First of all, you have to launch Excel and input your data with table into Excel spreadsheet. This is quite simple for you. After that, highlight the data in the table cell that you wish to use for the graph.

highlight excel data

Step 2. Choose the “Insert” option in the header of Excel tool bar. Click on the Line Chart button in the Charts group. After that, choose your target chart from drop down menu.

bar graphs

Step 3. Now you can see the graph shown next to your table. Its content is synched with your table data and each of them are appeared with X axis and Y axis

bar graphs

Step 4. At last, you had better give a chart title of your graph. Click on the “Chart Title” and enter the text for the line graph.

title line chart

Extra Tips: How to Recover Excel Password

By the way, if you created a password in Excel spreadsheet, however, you can’t remember the password for various unknown reasons, check out SmartKey Excel Password Recovery software, which is a professional Excel password unlock tool to figure out lost Microsoft Excel password with powerful password attack technology (brute force attack, brute-force with mask attack and dictionary attack).

smartkey excel password recovery

Now you have learned this 2017 guide about how to make a graph in Excel 2016/2013/2010/2007/2003, welcome to share more tips about it in the comment section.

Download SmartKey Excel Password Recovery:

Free Trial Buy Now

Only $19.95

Secure Download
30 Days Money Back Guarantee
comments powered by Disqus

Online Password & Key

Crack and get back all your online webiste password such as facebook and twitter

Connect with SmartKey

Copyright©2007-2019 SmartKey Password Recovery. All rights Reserved.