Search code examples
arraysgoogle-sheetsgoogle-sheets-formulasparklines

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.

Solution

  • try like this:

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

    0