Add Normal Range to Sparklines?

Copper Contributor

Is there a way to add a normal range to a sparkline? See below.

sparkline.PNG

3 Replies
Only by using a formula in an adjacent cell: ="Glucose "&B2 (B2 contains the 6.6)

Thanks although I was referring to the green shaded bands within the sparkline itself that define the normal range.

O, right, That you can only do using regular charts I guess. Like this add-in allows you to do: http://sparklines-excel.blogspot.com/