I would recommend pivoting your dates and values into one column:
You could then use a dual axis to combine shapes and lines.
My two cents are that the sheer number of colors and symbols may
make it difficult to interpret. Others may have some suggestions
on how to reduce the complexity. I quickly mocked up a parameter
that highlights a selected serial number.
209939inc.twbx 39.3 KB
I agree with Swaroop, you need to reshape your data before trying to create your visualization. If you using Excel sheet and able to use the Pivot function, do that. If not, you'll need to write some Custom SQL.
For more info on why you need to reshape your data, please refer to this article.
I had tried reshaping my data precisely as you had but what I was missing was the "dual axis" action. After doing this, things made much more sense. Thank you so much for your help (and especially for including an example workbook - this especially made things much clearer)!
Thank you for confirming what Swaroop suggested and for providing documentation on why it is necessary to reshape the data. By understanding the theory behind it, things made much more sense to me.