1 / 14

Using Excel to Create Charts and Graphs

Using Excel to Create Charts and Graphs. Computer Applications (N. Anthony, Johnson High School) . CHARTS AND GRAPHS. A picture representation of numerical data Cannot create a chart if you do not have numerical data Source of numerical data—Excel Spreadsheet

malaya
Download Presentation

Using Excel to Create Charts and Graphs

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. Using Excel to Create Charts and Graphs Computer Applications (N. Anthony, Johnson High School)

  2. CHARTS AND GRAPHS • A picture representation of numerical data • Cannot create a chart if you do not have numerical data • Source of numerical data—Excel Spreadsheet • An excel spreadsheet must be developed before you can create any charts.

  3. ADVANTAGES OF CHARTS • People had rather view charts than numbers • A Picture is Worth a Thousand Words • A Chart makes it easy to see the “BIG” picture • Can analyze a chart much faster than a table of data

  4. TYPES OF CHARTS • Bar or Column • Line • Pie

  5. BAR CHARTS (column) • A chart that shows how many times something happens or occurs • Either vertical or horizontal bars representing the number of times something happens • Example: How many males and females are in a particular class or How many people have an A, a B, a C, or an F average in a class.

  6. LINE CHARTS • A chart that shows how something has changed over time. • Shows trends • Uses lines with points to represent data • Example: Show how the price of gas has changed over the last 12 months.

  7. PIE CHARTS • Shows how the individual parts of something relate to the “whole” • Shows the percentages that each part is of the whole. • Similar to bar, but doesn’t show how many, but what percentage

  8. SPREADSHEET DATA USED TO CREATE A CHART • X-series of Data • Y-series of Data Before you can ever create a chart, you MUST be able to identify 2 ranges in a spreadsheet!!

  9. X-SERIES OF DATA • Data in spreadsheet that identifies each individual bar, point, or slice in a chart. • Usually with be labelsortext in the spreadsheet. • Can only have one X-series of data • X-series of data appears at the bottom of line and bar charts and identifies each slice in a pie chart.

  10. Y-SERIES OF DATA • Data in a spreadsheet that actually builds the lines, bars, or slices in a chart. • The Y-series of data MUST be actual numbers or values in the spreadsheet. • You can have multiple Y-series of data in a chart.

  11. Y-SERIES X-SERIES Example: I want to chart how Mary Benton’s grades changed from Test 1 to Test 3.

  12. Y-SERIES X-SERIES Example: I want to chart how everyone did on the 2nd test of the semester.

  13. RULE OF THUMB!! • If your Y-series of data runs left to right, your X-series of data will also run left to right. • If your Y-series of data runs up and down, your X-series of data will also run up and down.

  14. Develop the Excel Spreadsheet fully. Highlight the Y-series of Data Click on INSERT menu Click on CHART option Choose type of chart you want to develop Click NEXT Click onSERIES Identify the X-series of data Click NEXT Specify all Chart titles Move through all the tabs choosing appropriate options (discuss later) Click FINISH Specify where the chart will be located (either As a New Sheet or An Object In STEPS TO CREATING A CHART

More Related