• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

dynamic sparkline between ref month and observed month


hi guys, girls
I hope you are well. I need your help.
I am building a dashboard.
tracking monthly data following process steps.

in my dashboard, I compare the month observed (often the last month) but not necessarily with the reference month which can evolve via a drop-down menu.

In my excel, the observed month is in F2
the reference month is in H2

I would like to use sparkling conditioned to the time boundaries of my data (reference month to observed month)
in short a time interval potentially lower than the range of my data min and max.

How to do it please.

If you know of any nice monthly flow observation dashboard, I'm interested
Thank you in advance and Merry Christmas to you.


  • Classeur2.xlsx
    14.1 KB · Views: 6
One way is to use a dynamic range with INDEX ( ) : INDEX ( ), combo. The colon tells the second INDEX to create an array "from - to".


  • Classeur2_DynamicSparklineRange.xlsx
    13.8 KB · Views: 10