Close this search box.

How to create dynamic sparklines for latest 30 days



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?

Dynamic Sparklines using Excel

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:

Small Business KPI Dashboard - part of Excel school online class material

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.


Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

12 Responses to “How to create dynamic sparklines for latest 30 days ”

  1. Kaushik Pola says:

    Its Awesome !!

  2. Faisal says:

    Hello Chandoo,

    Thanks for sharing this insight for Sparklines.

    I am wondering if there's an easy method like this for charts where we just want to use data for last 30 days or 12 months.

    I remember reading somewhere on your web that offset formula can be used to do this thing however is there any simple way to accomplish it? Also, if could please share the link of that post here then it will be really helpful.

    Hope this is clear. Thank you.

  3. feldspath says:

    Very nice and simple trick !!!

  4. Melissa K says:

    Great technique that I'm sure I'll be using in future dashboards! Thanks Chandoo.

  5. Jeremiah Minifield says:

    Thanks Chandoo. I've never used sparklines. You've opened a door to more learning about Excel capabilities.

    Grace and Peace,

  6. cinnabar says:

    So, all in all you just limit your dataset by sourcing the plotdata from the first 30 entries of a sorted pivot table. Sleek .

  7. Taratin says:

    Thanks for this very useful trick.

  8. Irfan says:

    Thanks chandoo to provide such a useful tips.
    I want to learn Production and sales regarding chart for 12 months and 30 days with pivot table.

  9. Ramesh says:

    Good Morning.
    Awesome.... It is very awesome trick.
    I did not use this before.
    Now I learned and start to use this.
    Thanks Chandoo.

  10. Awesome Wally says:

    Great Idea! Offset and Named ranges don't with sparklines so this is a quick and easy workaround.

  11. Matthew Kuo says:

    Thanks Chandoo, great tip! I've always debated the usefulness of sparklines in general, but making them dynamic and giving them a little more real estate definitely improves the case for utilizing them.

  12. Meet Dedhia says:

    Hey, thank You! That was very informative. While I like your approach, my suggestion would be to keep it short. While you used a Pivot table, you could have simply used a filter on the columns. Please suggest if it gives any errors while using filters?

Leave a Reply