Join Richard Harrington for an in-depth discussion in this video Using a column chart, part of Excel 2013: Working with Charts and Graphs.
- Now that we've got the essentials down…for inserting a chart…let's take a look at specific chart types…and when to use them.…We'll start with one of the most common,…a column chart.…If your data can be arranged into rows or columns…within your Excel spreadsheet…then it's a good candidate for turning into a column chart.…In this case, let's take a look at some of the data.…We've got shipments that were projected…versus actual shipments made by the company.…A little later on we'll break those shipments down…by their type but for now let's track the individual data.…
Well, if I wanna show just the projected shipments…I can highlight just that range of information…and when I choose to insert a chart…you'll see that that information…is well suited as a column chart.…If we click the pop up here and mouse over…you get the idea of what's available.…I'm gonna choose to work with the Recommended Charts option…and then go to All Charts so it's easier…to show you the visualization.…
Let's start with Column here.…By working with a clustered column…
- 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.