1 / 7

How to Create a Line Graph Using Excel

How to Create a Line Graph Using Excel. Tim Hoblitzell. What Excel Offers. Excel offers many different things to do with data such as : Creating charts based on the data that you provide. Organizing data Creating tables Calculating the data based on different formulas.

tyrell
Télécharger la présentation

How to Create a Line Graph Using Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. How to Create a Line Graph Using Excel Tim Hoblitzell

  2. What Excel Offers • Excel offers many different things to do with data such as : • Creating charts based on the data that you provide. • Organizing data • Creating tables • Calculating the data based on different formulas

  3. Why You Need To Know How To Create A Line Graph • Line Graphs are very important when it comes to businesses. • Some uses for a line graph are : • Show how your business is doing, such as revenue. • Show how sales are doing over a certain time period • Showing the companies growth.

  4. Writing Data • If you plan to use Excel for organizing data, you are going to want to label your data. • You would normally use row one as your title cells • Following that, row two is when you start writing data.

  5. Creating a Line Chart You want to highlight the data you want to make the chart about. After highlighting the Data go to the tab the arrow is pointed to.

  6. Creating a Chart Cont. • These are the choices you have to chose from when creating a chart. You are going to want to click this one.

  7. What It Looks Like This is an example of a Line Graph based of data used in Excel.

More Related