Join Dennis Taylor for an in-depth discussion in this video Scatter charts, part of Excel: Charts in Depth.
- [Instructor] If you're trying to show the relationship … between two different sets of values. … You might consider using what's called a scatter chart. … And often, this is referred to as an X Y chart. … There's a companion chart called a bubble chart … that we also want to take a look at. … On the sheet called X Y scatter chart, … we've got data in columns A and B. … Ages are listed in column A, … these people have run a race, … we've got their completion times in column B. … 99 entries here. … We'd like to show this information in a chart. … Click anywhere within the data, … it is surrounded by empty cells, … and worksheet boundaries, … so we don't have to highlight it. … And on the insert tab in the ribbon, … there is the icon for X Y scatter or bubble chart. … Choose the first option, … and we see the chart already down below. … Move this over, make it a little bit bigger. … Each point here represents information we're seeing … in one of the rows off to the left. … So this point right here for example, …
Author
Released
9/26/2019- Chart essentials
- Fine-tuning charts with design tab choices
- Inserting pictures, shapes, and text boxes
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Changing a chart's data source
- Printing and sharing charts
- In-cell chart alternatives
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: Advanced Formulas and Functions
with Dennis Taylor4h 35m Intermediate
-
Introduction
-
1. Chart Essentials
-
Overview of chart types3m 11s
-
Choose styles and layouts3m 42s
-
Change chart orientation3m 26s
-
2. Fine-Tune Your Charts
-
Add a chart element2m 31s
-
-
3. Adjust Chart Elements
-
Modify axes3m 22s
-
Link titles to content2m 59s
-
Add and edit data labels3m 28s
-
Add a data table3m 9s
-
Work with gridlines3m 19s
-
Use legends3m 22s
-
-
4. Format Tab Options
-
Work with shapes and arrows2m 56s
-
Add shape styles and effects3m 31s
-
Work with chart text2m 53s
-
Apply WordArt styles2m 5s
-
5. Work with Popular Chart Types
-
Column and bar charts3m 16s
-
Line and area charts3m 25s
-
-
6. Other Specialized Excel Charts
-
Combination charts3m 23s
-
Stock charts3m 30s
-
Scatter charts3m 30s
-
Bubble charts3m 27s
-
Radar charts3m 26s
-
Gantt charts3m 31s
-
-
7. New Excel Chart Types
-
Overview of new chart types2m 23s
-
TreeMap charts3m 24s
-
Sunburst charts1m 51s
-
Histogram chart3m 18s
-
Box and whisker chart3m 30s
-
Pareto chart2m 21s
-
Waterfall and funnel charts4m 19s
-
-
8. Change a Chart's Data Source
-
9. Print and Share Charts
-
Print charts3m 48s
-
-
10. In-Cell Chart Alternatives
-
Conclusion
-
Next steps25s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Scatter charts