Sparklines

Question

Hello,

I need to create  sparklines for a set of data that keeps changing based on a selection.

I am trying to give a dynamic range for the data range like [ =R5 : OFFSET(R5,0,A1-1) ] because the data in the source gets populated by the value in cell A1.

When I give a formula for data range excel returns a error message "Data source reference is not valid".

Any help is welcome to fix this.

Thanks

SS

Answer 1

For me its working absolutely fine. I will suggest you to do exactly same what I did in my previous thread in a new workbook. Once it works fine then you do in your final file.

Still if you face issue, please upload your file with sample data on Onedrive and share the link here.

Answer 2

For this create a Name.

Go to Formula/Name Manager/New/Give a name say its "Spark"/Now there give this formula in refer to,

=OFFSET(Sheet1!R5,0,,,Sheet1!$A$1)

Now in your sparkline range give formula as 

=Spark

Hope it helps

Answer 3

Hi Vijay,

Getting the same erroe message;