Join Richard Harrington for an in-depth discussion in this video Using a bar chart, part of Excel 2013: Working with Charts and Graphs.
- Earlier we talked about the use of a column chart.…Well, a bar chart is just a column chart turned on its side.…And a bar chart is useful when you have a lot of data.…It can get a bit crowded trying to squeeze…everything in horizontally…but when you flip it vertical…you've got the ability to scroll and to fit more in there…plus it might be easier to track changes or trends…to see how one thing performs against another.…Let's select that information here and build it up.…So, we're gonna start…and take a look at our projected shipments by quarter.…
Remember, make sure you choose…the headings in your selection…then choose Insert, Recommended Charts,…and I'll go to All Charts.…If you don't have that Recommended Charts button…you could just specifically jump right to the bar chart.…You'll see in this case, a couple of options.…Do you wanna see just the bars over time?…Here we could track how are we doing.…For example, I see that overall sales have grown from time…but we always tend to have a really strong fourth quarter.…
- 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.