Join Richard Harrington for an in-depth discussion in this video Using a scatter or bubble chart, part of Excel 2013: Working with Charts and Graphs.
- Sometimes you have a lot of data that you've collected.…Maybe you've sampled several different people or locations.…Or perhaps you have different segments…and you've collected data from those segments,…and you want to show the overall relationship.…This can be done on the X-Y axis…and it's not as dependent upon time values.…In this case a scatter chart works pretty well.…Having an extra header up here…can really confuse the application.…So let's simplify it so that the headers clearly line up…with the data that they're addressing.…
All right, we'll select the entire table there,…and choose Insert, Recommended Charts.…I'll go to the All Charts view, and jump down to Scatter,…and you'll see the ability to track the changes.…In this case, I see that with the change in population,…the incidence of lack of pigmentation…and hazel-colored eyes grew over time.…That's quite useful.…But it's not at a constant rate.…If you want to make that easier to see,…connecting the dots with a line…can show you the erratic nature of the pattern.…
- 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.