Скачать или смотреть Excel Add Sparklines on a Separate Worksheet

Sparklines are awesome Excel mini-charts you can add in just a cell. They are great for visualizing data, trends, or data across periods. In this video, I show you how to add sparklines in a separate worksheet by referencing data in a different worksheet. They work great this way to create a 'summary worksheet' if necessary.

I discuss the different types of sparklines you can add, where to find them, and how to change them. We look at creating sparklines for a bunch of products across a year, and then we look at how to visualize the high and low points, making the data the same on all rows so that it shows you the differences correctly.

Finally, I show you an example that adds a second set of sparklines, this time with data from a different sheet but also across several columns, to show changes across the full period.

Chapters:
00:00 Introduction
00:20 Sample data
01:07 Types of sparklines
01:32 Insert line sparklines
01:56 Change the type of sparklines
02:15 Sparkline High and Low Points
02:34 Change Sparkline Axis
03:02 Creating a comparison
04:48 Closing remarks

I've discussed sparklines before in a few videos, here they are in case you want to check them out:

5 Sparkline Tips:    • Excel Sparklines - 5 Tips for Sparklines  
Show trends with sparklines:    • Excel Sparklines to show Trends - Mini Cha...  
Quick analysis with charts and sparklines:    • Quick Analysis in Excel - Charts, Totals, ...  
Sparklines in Excel:    • Sparklines in Microsoft Excel by Chris Menard  

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #sparklines #chrismenardtraining