Sparklines, which were invented by Edward Tufte and detailed in his book…"Beautiful Evidence", summarize data in a compact word-size chart that fits…inside a single worksheet cell.…There are three different kinds of sparklines that you can create in Excel:…line, column, and win/loss.…In this movie, I'll show you how to create them and point you to the formatting…tools you can use to change their appearance.…The line and column sparklines are simply smaller versions of line and column…charts you've seen elsewhere in this course.…Win/loss is a little bit different, but I'll show you how to work with it when we get there.…
So the first question is, how do you create a sparkline?…Well, to do that you first click the cell where you want the sparkline to go,…and then, on the Charts tab of the Ribbon, in the Insert Sparklines group, you…click a button for the sparkline you want to create;…in this case, it will be a line.…So now from within the Insert sparklines dialog, I can go into the body of the…
Author
Released
10/26/2010- Customizing the Ribbon
- Formatting worksheets, cells, and cell data
- Sorting and filtering data
- Working with formulas
- Detecting formula errors
- Creating charts
- Importing data
- Inserting objects and graphics
- Using PivotTables
- Recording macros
- Sharing workbooks
Skill Level Beginner
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Introduction
-
Welcome1m 12s
-
-
1. Getting Started with Excel
-
Customizing the Ribbon4m 20s
-
Setting program preferences3m 20s
-
Getting help in Excel4m 16s
-
2. Managing Workbooks
-
Setting workbook properties4m 14s
-
3. Managing Worksheets, Cells, and Cell Data
-
Creating an Excel table4m 43s
-
Sorting worksheet data3m 2s
-
Creating a custom sort order3m 54s
-
Filtering worksheet data4m 6s
-
Managing worksheets5m 28s
-
4. Summarizing Data Using Formulas and Functions
-
Adding a formula to a cell3m 59s
-
Creating an AutoSum formula3m 22s
-
Managing scenarios4m 59s
-
5. Formatting Worksheet Elements
-
Managing text alignment3m 56s
-
Copying cell formats4m 2s
-
Managing cell styles3m 16s
-
Managing Office themes3m 31s
-
6. Working with Charts
-
Creating pie charts2m 32s
-
Creating line charts4m 34s
-
Creating XY (scatter) charts1m 49s
-
Creating stock charts4m 11s
-
Adding trendlines to charts4m 14s
-
Creating sparkline charts4m 31s
-
7. Working with External Data
-
Using hyperlinks6m 1s
-
8. Working with Objects
-
Adding and adjusting images5m 38s
-
Creating WordArt2m 34s
-
9. Exploring PivotTable Reports
-
Creating a PivotTable report4m 37s
-
Pivoting a PivotTable report3m 17s
-
Applying a PivotTable style2m 20s
-
Creating and editing styles2m 59s
-
10. Reviewing and Sharing Your Spreadsheets
-
Checking spelling3m 32s
-
Managing workbook comments3m 40s
-
Exporting to other formats1m 33s
-
Protecting a workbook2m 36s
-
-
11. Automating Workbooks Using Macros
-
Running an existing macro4m 56s
-
Recording a macro3m 56s
-
Adding comments to a macro2m 43s
-
-
Conclusion
-
Additional resources1m 1s
-
- 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: Creating sparkline charts