Monday, January 3, 2011
How to Make a Line Graph in Excel
Posted on 7:01 AM by Unknown
How to Make a Line Graph in Excel
If you are clueless about how to make a line graph in Excel 2007 and 2010, you have landed on the right page. Here, I provide you with simple guidelines on how to make a line graph in Excel 2007 and 2010 versions. Only those who have spent hours together, in drawing graphs manually with the aid of a graph paper and a calculator, can appreciate the luxury that software programs like Microsoft Excel provide of creating line graphs automatically. If you are a business manager, student, scientist or any one who is associated with analysis of large amounts of data, it's essential that you know how to make a line graph in Excel 2010 or 2007. The aim of this article is to provide you with a step by step guide on making line graphs using Excel software, which is the premier spreadsheet software used around the world.
Be it analyzing your company sales, balance sheet analysis, studying your income and expenses, drawing graphs for experimental data to calculate slope or to study any other accounting statistics, it's important that you know how to draw a line graph using Microsoft Excel or any other spreadsheet software like Open Office Calc.
Drawing graphs helps you interpret data in graphical form. That's what makes it an important analysis tool. Let me walk you through the procedure of how to make a line graph in Excel 2007 or 2010, in the next section.
How to Make Line Graph in Excel 2007?
I assume that you either have Microsoft Excel 2007 or 2010, installed on your computer. In this article, I describe how to make a line graph in Excel 2007. If you are curious about how to draw a line graph in Excel 2010, then know that the procedure is same as Excel 2007. To begin with, ensure that you have the data, on basis of which, you are making a line graph. Open Microsoft Excel and open a new spreadsheet.
Step 1: Enter Data Accurately in Columns
The first and the most important step of making a line graph is accurately entering the data into columns. To be able to draw an X-Y axes line graph, you need to have a set of matching data points. Divide the data into columns and make sure that every column is labeled at the top. Ensure that every cell in the columns is filled up and there are no blanks left.
For example, if you are making a line graph of sales figures for the past five years, make a data column for year and another one for the sales figures. Ensure that the data is entered correctly in adjacent columns. The first column will be taken as the X axis data by default.
You may have more than one data columns, plotted against the first column, which will be plotted on the X axis. To make double line graph in Excel, enter data in two columns, after the first data column, whose data will be the X axis reference.
Step 2: Select Data for Graph Plotting
Once the data is entered, select all of the data columns, along with the data labels. Then open the 'Insert' tab, provide at the top, by clicking on it. Be careful that all the data, which you wish to be plot on the graph, is selected.
Step 3: Choose the Insert Line Graph Option
In the chart option provided there, you will find a line graph option, with several templates of the types of line graph you want. You may want to select 'Line with Markers' type of line graph. Once you choose and click on the right type, immediately a line graph representing the data will be visible on the spreadsheet. It will be a double line graph, if you selected three columns. So you are essentially done with plotting the data and creating a line graph.
Step 4: Define Features of Line Graph
All that remains is defining things like the legend, the title, background color and font color for the graph. Click on the graph and open the graph or chart design options provided above. The functions provided above, let you define the basic design, layout and formatting of the graph. Select the combination of features which suits your style. Once the designing is done, your graph is ready for use.
Hope, this short guide on how to make a line graph in Excel 2007 and 2010 was easy to understand and you now know, how to use excel to do so. The only way to actually learn using the features of programs like Microsoft Excel, is to practice using it. Open up Microsoft Excel right now and enter two sample data columns to make a line graph. The best part about using computer softwares, such as Excel, to handle data is that you don't need to worry about making mistakes, as there is always the 'undo' function at hand. I am sure that you will master the art of making line graphs on Excel, in a matter of minutes!
By Gray Pilgrim
Feel Free to share this blog post with your friends using the share buttons below this post.
If you have anything to contribute or ask, Kindly make use of the comment form below.
Please, do not forget to SUBSCRIBE to this blog, so that you can be receiving future Information Technology News,money making tricks,browsing cheat latest I.T Jobs,latest I.T career article DIRECTLY into your email inbox, even when you are not online.
We also offer Computer Engineering and Networking Training,Sales of both Laptop and Desktop Computer @ a very cheap price
NOTE: If the LINKS are NOT clickable, it simple means you are not reading this at www.olamoshsystem.com. So, visit WWW.OLAMOSHSYSTEM.COM now to read the original article.
Phone number:08026652529
E-mail Address:olamosh.system009@gmail.com
Join me on facebook:www.facebook.com/olamoshsystem
Website address:-www.olamoshsystem.com or www.latestdreamjob.blogspot.com
Group name on facebook:Information Technology(OLAMOSH SYSTEM LTD)
Group name on facebook:(LATEST DREAM JOB)
If you have anything to contribute or ask, Kindly make use of the comment form below.
Please, do not forget to SUBSCRIBE to this blog, so that you can be receiving future Information Technology News,money making tricks,browsing cheat latest I.T Jobs,latest I.T career article DIRECTLY into your email inbox, even when you are not online.
We also offer Computer Engineering and Networking Training,Sales of both Laptop and Desktop Computer @ a very cheap price
NOTE: If the LINKS are NOT clickable, it simple means you are not reading this at www.olamoshsystem.com. So, visit WWW.OLAMOSHSYSTEM.COM now to read the original article.
Phone number:08026652529
E-mail Address:olamosh.system009@gmail.com
Join me on facebook:www.facebook.com/olamoshsystem
Website address:-www.olamoshsystem.com or www.latestdreamjob.blogspot.com
Group name on facebook:Information Technology(OLAMOSH SYSTEM LTD)
Group name on facebook:(LATEST DREAM JOB)
Subscribe to:
Post Comments (Atom)
Feedage
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
1 Response to "How to Make a Line Graph in Excel"
After you have selected the Chart type, click and hold your mouse pointer down on the Press and Hold... button to see what your data looks like in the chart type you selected. If you do not like the look, select another chart type. After you have selected the chart type you will have two options
www.cheapestusedcomputer.com
Leave A Reply