Hello folks,
I have searched google and these forums for a bit but have been unable to find an answer to my question.
I am looking to insert a sparkline into 'Sheet 2' from data that is in 'Sheet 1'
Sheet_2 is a dashboard which I am creating and I want the opportunity to be able to change the Item# in the column and have it update the sparkline accordingly
I tried using the OFFSET function but it is producing an error for me 'Data source reference is not valid'.
Any thoughts on how I can fix this?
The Data Range that I am specifying when creating a sparkline is as follows:
=OFFSET(Sheet_1!A2,MATCH(Sheet_2!A2,Sheet1!A:A,0),1,1,4)
For example:
Sheet_1 (this is the sheet with the data)
Item..........1/2017.......... 2/2017.......... 3/2017.......... 4/2017
15400020.. 1232............. 23928........... 23212........... 21323
99402.......123423........... 4243636......... 4523423....... 234234
10144.......13215...........456454654........46486...........456454
9102905....545645.......2352323............23535.............235235
Sheet_2 (this is the sheet with the dashboard)
Item............. Sparkline
10144
99402
Any help would be appreciated!!
I have searched google and these forums for a bit but have been unable to find an answer to my question.
I am looking to insert a sparkline into 'Sheet 2' from data that is in 'Sheet 1'
Sheet_2 is a dashboard which I am creating and I want the opportunity to be able to change the Item# in the column and have it update the sparkline accordingly
I tried using the OFFSET function but it is producing an error for me 'Data source reference is not valid'.
Any thoughts on how I can fix this?
The Data Range that I am specifying when creating a sparkline is as follows:
=OFFSET(Sheet_1!A2,MATCH(Sheet_2!A2,Sheet1!A:A,0),1,1,4)
For example:
Sheet_1 (this is the sheet with the data)
Item..........1/2017.......... 2/2017.......... 3/2017.......... 4/2017
15400020.. 1232............. 23928........... 23212........... 21323
99402.......123423........... 4243636......... 4523423....... 234234
10144.......13215...........456454654........46486...........456454
9102905....545645.......2352323............23535.............235235
Sheet_2 (this is the sheet with the dashboard)
Item............. Sparkline
10144
99402
Any help would be appreciated!!