sparkline with no adjacent range

[krodriguez]

Hello - I want to create a sparkline with with no adjacent range I have values in B2, C2 and E2, F2, G2 I have added a name range to these cells but when I tried to plug the values in the sparkline getting error data range not valid. Help?

Thanks!

 

[daverunt]

As I understand it at this link:
You can do it with a non-contiguous range.

https://chandoo.org/forum/threads/sparklines-using-non-contiguous-range.13830/


Hold CTRL and select the cells or blocks of cells for the range. Name it ? Sparky ?
Insert Sparkline and enter =Sparky as the range.

It appears to omit several blank cells in a row when I tried it.
It doesn't seem to need the '=' either