Creating a sparkline using a non-contiguous range

[krodriguez]

Hello, trying to put together a sparkline using a a non-contiguous range and getting errors, any ideas on how to achieve this?

 

[sykes]

Give the non-contiguous range a name (named range), then use the name for the sparkline. No need for quotes or an "=" just type the range name straight into the "datarange" box.

 

[krodriguez]

I named the range but when creating the sparkline getting error that data range is not valid. if I select my range I can see the name I assigned when going to add the sparkline and I select each cell that I need in that range is doesn't work.