ToolTip Chart Data Issue

[AfnanAbuArida]

Hello,

I would appreciate your help in creating a line chart for the linked data. I would like when hovering over any financial instrument's name to get a line chart that shows its 5-day performance, but I found no way to have all the almost 400 instruments and their prices and the dates to be included in a line chart. It looks more like this instead: 

https://docs.google.com/spreadsheets/d/1imaV0IRofBc7AvUDmv_MkQ69aTXPE34Q/edit?usp=sharing&ouid=11341... 

Thank you! 

[lbendlin · Accepted solution]

No need - you can add a sparkline directly in your table.

You need to unpivot your data though.