Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Apply a common vertical axis and formatting to a Sparkline group:

Lesson 4-21 from: Microsoft Excel 2016 Essential Skills (138 Video Lessons)
This video walkthrough does not have voice narration. It is intended to be used as a supplement to the printed book or e-book.
You can purchase the books and e-books by clicking here.
Apply a common vertical axis and formatting to a Sparkline group
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2016 Essential Skills
Session: Session 4: Making Your Worksheets Look Professional
Lesson: Lesson 4-21 Apply a common vertical axis and formatting to a Sparkline group Group Excel Sparklines. Thumbnail from Excel 2016 Essential Skills Lesson 4-20 Apply a common vertical axis and formatting to a Sparkline group.
Description:

This video lesson shows how to apply a common vertical axis and formatting to a Sparkline group in Excel 2016. Sparklines can be deceptive as (by default) they do not share a common vertical axis. This lesson makes them represent values in the entire dataset by applying a common vertical axis. This lesson also demonstrates Sparkline formatting options. You can apply different colors to each bar in a column Sparkline to show the High Point, Low Point, Negative Points, First Point and Last Point. You will also discover how to change the thickness of a line, change the color or a line and show markers (dots for each data point) in a Line Sparkline. In this lesson you will also learn how to delete a Sparkline without deleting the column that contains it.