Input Control - Sample 2, Sparkline data

Please help I have a sparkline data in excel "0,0,0,0,3,7,2,0,0,0,0,0" but klipfolio take a number 37,000,000. Thank you in advance

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Miguel, 

    Thanks for contacting Klipfolio support! 

    You can use the ARRAY function to split up a comma separated list of numbers into a row-by-row array of numbers. For example, if you had set up a formula of ARRAY(@G2), the output would be as follows:

    With that in mind, if you'd like to display your comma separated list of values as a series on your chart, I'd recommend using ARRAY as described above.

    I hope this helps! If you require further support on this, be sure to reach out to support@klipfolio.com.


Please sign in to leave a comment.