Join Richard Harrington for an in-depth discussion in this video Using an area chart, part of Excel 2013: Working with Charts and Graphs.
- If you have data that can be arranged into a table…oftentimes this can be represented in an area chart.…I like to use an area chart when I want to show…two different pieces of information.…For example, I want to track the growth…in a particular item as well as look…for trends from year to year.…This gives me the overall combination of values…and the ability to spot any changes…or fluctuation over time.…If you look at our data here,…let's just zoom in a little bit,…you see the total number of units sold…for a particular model but I've tracked…the individual sale by color.…
What I'd like to see is what's happening…with this information.…Now, let's make this a little bit easier…and make a selection here…and press ctrl + T to make a table.…I'll tell it that there are headers on this…and click OK.…This makes it a bit easier to format the data.…Now, what I want to do is sort this column alphabetically.…You see now that the colors are sorted…based on alpha-numeric value.…
Let's select this information here,…we'll grab the whole table,…
- Creating a chart
- Picking a chart type
- Displaying data with tables
- Editing data in a chart
- Adding SmartArt graphics
Skill Level Appropriate for all
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.