Sparklines with dynamic (named) range not working

Hello,

I'm trying to create a sparkline that references a single column of about 50 rows. Ideally, I'd like the x-axis to scale based on new data that are entered vertically.

The data are going to be in B3:B52 (50 cells in all). Right now, there are only 20 datapoints entered as an example (B3:B26) and there are some blanks within that range, intentionally.

-

I've used the below formula in the name manager and set the sparkline's source to that named range, but it still produces a sparkline that is sourcing all the empty cells (B3:B52 instead of B3:B26) that don't have data in them just yet.

Please Login or Register  to view this content.

-

Then, I tried the below formula, expecting that it would increase in height as more data were added. Instead, the offset range is still static (D3:D52 instead of D3:D26) and there's no sparkline shown in the target cell.

Please Login or Register  to view this content.

-

Maybe the sparkline isn't showing because the named range is producing an error?

The example workbook is attached. The first dataset is the more complex formula and the second dataset is the one that kind of works but doesn't scale the x-axis.

Update:

Seems I've found a solution by entering this formula in the name manager and setting the sparkline's source to it:

Please Login or Register  to view this content.

And the data are in C3:C52

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.