Adding a row and incorporating that change in a Sparkline

[Jwow]

Hi All,

Here is my issue.
Currently, I have a sparkline graph that represents historical data. I would like to add additional rows to the report every month. Unfortunately the data range that i provide to the sparkline changes as i have added a new row each month, and does not incorporate the new row that i have added. So I have manually change the data range for the Sparkline (unfortunately i have hundereds for Sparklines to update). So I am wondering how can I insert a new row each month and have that automatically incorporated in the existing Sparkline.

Any help or guidance is much appreciated.

-J

 

[UniMord]

How about setting your sparklines to refer to a dynamic range?