Excel Sparklines - 5 Tips for Sparklines

[@phungquyen3511]

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

[@ChrisMenardTraining]

Happy to help!

[@markpodesta4605]

Thank you Chris. I like using sparklines.

[@ChrisMenardTraining]

I do also. Thanks, Mark!

[@tonybou-abboud48]

Thank you Chris 👍

[@ChrisMenardTraining]

Very welcome. Thanks, Tony.

[@hazemali382]

Amazing Mr. Chris👍

[@ChrisMenardTraining]

Thank you!

[@islamzahran8561]

Thank you Chris

[@Launa-uq8qx]

Thanks, Great Video

[@devndrksarda8651]

I have a large data which has occupied all the columns of my worksheet 1, so i have to put the new data in worksheet 2. is it possible to create sparklines by selecting data from both the sheets? If yes, please help me do that.

[@marcw.5492]

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.

[@peterschel6]

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.

[@bencodykirk]

In the video, Chris set the sparklines to all use the same vertical axis scale, but you can also set your own scale by choosing "Custom Value" for both min and max. I tried this and it seems to help a bit. I used a min of 0 and a max of 150.

[@BD-su9fn]

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,).