Excel Sparklines - 5 Tips for Sparklines

Sparklines in Excel are miniature charts. Sparklines are great when you need to show fluctuation or trends since they give you a visual representation of your data. I have five tips for using Sparklines. Sparklines are located on the Insert tab and have their own group, called Sparklines. There are three commands for sparklines - Line, Column, and Win/Loss.

Chapters:
00:00 Introduction
00:15 What are sparklines?
01:25 Tip 1
01:58 Tip 2
02:21 Tip 3
02:44 Tip 4
03:35 Tip 5
05:02 Bonus tip
05:16 Closing remarks

#chrismenardtraining #msexccel #exceltraining #sparklines #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

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!

[markpodesta]

Thank you Chris. I like using sparklines.

[phungquyen]

These are really helpful tips. Thanks a bunch, Chris.

[marcw.]

Great tips ... I wonder why you cant manipulate the lines more ? Like thickness and smoothness - 2 things we use frequently in all our charts. We used the Bizzantz APP for years and they went away. Much nicer look.

[peterschel]

Hi Chris,

Thank you for all these helpful tips!

I do have one question.

The proportions of the sparklines are out of balance if you ask me. For example product 1 / march - may. The sparkline of may should be almost half as big as march but that isn't the case.

How can you make the proportions better without having to change the minimum and maximum value of the vertical axis of every sparkline? Is there a way to make a bandwith regardless of the height of the amounts?

I hope you can help me out.

[BD-sufn]

It's too bad they don't offer more options for data that is not linear (like if you have data points at t=0 days, t=2 days, t=5 days and t=9 days, ).