Join Curt Frye for an in-depth discussion in this video Summarizing data using a chart, part of Up and Running with Public Data Sets.
- View Offline
- Exercise Files
- One of the best ways to summarize data effectively…is to visually represent the data in a chart.…In this movie, I will show you how to create…a line chart in Excel 2013.…But the techniques that I show you…will apply to any version of Excel from 2007 on.…My sample file is the OPEC-ORB.csv file,…and you can find that in the exercise folder…included with the course.…This file has a two-column data set.…
Column A is dates.…And I'll double click the right edge of the column header…to expand it so we can see the dates…and also the value of a barrel of oil…on that particular day.…I can look at the data and sort of see the visualizations.…But what I'd really like to do…is display it in a chart.…So I'll click any cell inside of the data list that I have,…and, to make things easier for me,…I will click Format as Table.…And click Table Style.…Verify that the data range looks correct,…and my table does have headers, and click OK.…
So I've created an Excel table.…There are a lot of benefits to creating an Excel table.…The most important to me…
- Working with US census data
- Using data from the Securities and Exchange Commission
- Accessing data from other US agencies
- Finding international sources of data
- Gathering data from web-based search engines and data portals
- Visualizing and analyzing public data sets in Excel
Skill Level Intermediate
1. U.S. Census Bureau and Securities and Exchange Commission
2. Other U.S. Government Agencies
3. Non-U.S. Data Sources
4. Data Search Engines and Portals
5. Visualizing Data
Manipulating a PivotTable2m 39s
Further resources1m 26s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.