Sparklines are fun and very insightful. They are easy to create, easy to maintain and fit into any dashboard.
But there is one tiny problem with them. Usually we have a lot of data, but we don’t to visualize all of it. We just want to visualize latest 30 days trend or last 12 months trend or QTD or something similar. What then?
In this video, learn a powerful and very simple way to create dynamic sparklines using Excel.
Create dynamic sparklines in Excel – Video
You may watch this video on our YouTube Channel.
Download dynamic sparklines example workbook
Please click here to download the example workbook for this post. Examine the chart & pivot table to learn more.
Sparklines = more power to your dashboards
I add sparklines to all my dashboards. They are elegant, space-saving and insightful. They are an integral part of my Excel School online class on Advanced Excel & Dashboard reporting. Sample this dashboard:
If you want to learn how to use sparklines & other powerful Excel features to create awesome dashboards, Please consider enrolling in our Excel School program.
How do you use sparklines?
Please share your favorite tips & implementations of sparklines in the comments section.
This post is part of our Awesome August Excel Festival.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.