Join Richard Harrington for an in-depth discussion in this video Using a line chart, part of Excel 2013: Working with Charts and Graphs.
- If you're looking to show a trend,…a line chart can be quite useful.…In the case of the data we were just evaluating,…we were tracking financial performance.…Now because this performance happened over time,…each quarter,…it wasn't really that the sales all happened on one day.…It's useful to see a trend by visualizing it with lines.…Let's start with the table selected.…I'd like to track the two types of shipments,…Actual versus Projected.…When I go to insert this,…I'll start with the Recommended Charts option,…and go over to All Charts,…and you'll see the ability to visualize this as Lines.…
What we're looking at here is to see…what was the plan versus how did we perform.…You see there's different chart types here.…If you just want to see the line,…the first option works well.…And where there's deviation,…this points out potential problems.…You'll note, for example,…that we had a lot of fluctuation early on.…Our Projected Shipments and our Actual Shipments…had a pretty large gap.…Later on, while sales were going up and down,…
- Explain the steps to take to create a chart in Excel.
- Recall the options for customizing an existing chart within Excel.
- Determine which chart type fits best with a set of data.
- Summarize the process of creating a table.
- Identify strategies for clarifying a table.
- List the steps to take to add SmartArt to a project.
Skill Level Intermediate
1. Chart Essentials
2. An Overview of Chart and Graph Types
3. Displaying Data with Tables
4. Working with SmartArt
Adding a SmartArt graphic3m 50s
- 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.