Sparklines with Dynamic Data and Locations

[articzap]

What I thought would be pretty simple is absolutely destroying me, and I can't figure it out.

I have a spreadsheet that uses dynamic arrays to update a dashboard based on some drop down selections. I want the sparkline data and location to update according to these dynamic arrays length. I've tried setting the named range to the dynamic array (U7#), but the sparkline always defaults to the length of they dynamic array at the time of entering the named range in the boxes. It does not keep the named range.

Any thoughts without having to use VBA would be helpful.

 

[My Aswer Is This]

You said:
I want the sparkline data

sparkline data ??
What is sparkline data?

 

[articzap]

So here is the before. Named ranges entering to the sparkline data fields.

After hitting 'OK' and reopening the sparkline data fields, the named ranges are gone, and its back to a static field. This also happens if I used '$U$7#' instead of 'SPARKLINES'.

I have attached a sample copy of my workbook for everyone to see, and if they can come up with a better solution.

easyupload.io
Password: test

 

[My Aswer Is This]

OK Thanks. I have never used Sparklines or heard of them.
I Will watch this thread to see what I can learn.

 

[uk747]

Maybe

' Sparklines will Appear in J3:J7, Source Range is C3:I7
' 3 Options for Sparklines - Line, Column or Win/Loss
With Range("$J$3:$J$7").SparklineGroups  ' Where Sparklines will Appear
  .Add Type:=xlSparkLine, SourceData:="Sheet10!C3:I7"               ' Line
  .Add Type:=xlSparkColumn, SourceData:="Sheet10!C3:I7"             ' Column
  .Add Type:=xlSparkColumnStacked100, SourceData:="Sheet10!C3:I7"   ' Win/Loss
End With

' Sparklines will Appear in Named Range Called SparklinesAppear, Source Range is Named Range MyRange
With Range("SparklinesAppear").SparklineGroups  ' Where Sparklines will Appear
  .Add Type:=xlSparkLine, SourceData:="MyRange"
End With