egflame
egflame

Reputation: 167

How to draw sparkline for values which are not followed directly by each others

I have some values in cells that are not followed by each other and scattered in cells where some values for the cells are blank or I want to exclude from being shown up in the sparkline.

Example: I wanna show up sparkline for values A1:E1 but B1 contains value I don't want it to show in the sparkline.

Upvotes: 1

Views: 317

Answers (1)

player0
player0

Reputation: 1

try like this:

=SPARKLINE({D5, F5, H5:J5})

0

Upvotes: 1

Related Questions