Thursday, May 25, 2017

yogi_Combine Several Sparkline Charts And Headers In An Array Formula (brute force method)

Google Spreadsheet   Post  #2169
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-25-2017
question by zr2ee:
averaging form submission data and optimizing formula's
i was able to transpose the formula's across the remaining columns that i'm averaging and am working to better understand the query functions, it's definitely powerful i just don't have a good grasp on it at this time.

Question number 2.

Is there a way to create a array type function with sparkline graph's
currently i'm using a formula in each cell of a column like this: =iferror(SPARKLINE('Step 3 (form)'!L2:R2,{"charttype","line"}))
but if possible i'd like to narrow it down to one header cell formula like the previous solution. 
I have hidden the sheets and columns unrelated to the question

1) please give us one Sheet (for the source data) ... don't give us the whole project
Source data sheet: (step 3 (form))
2) give us one sheet for the output
Output sheet: (Product 2 Validation)
4) just tell us what you are trying to accomplish
I'd like to use a single formula to create a set of sparkline graphs down a column of cells
5) tell us what is your expected result ... in which cell? of which sheet?
sparkline graph's down 'Product 2 validation'!H3:H comprised of data from 'Step 3 (form)'!L:R