The initial chart was drawn in Excel which uses arbitrary cell references and will plot whatever we want wherever we want. Tableau is fundamentally different in that it uses the elements of the data structure as a foundation for how marks are plotted, so there are times we need to change the data structure to get the desired result. Pivoting as Chris described is the way to go in Tableau.
Hi Chris and Jonathan,
Thank you for helping me out.
Originally, I tried to avoid pivoting date fields if I could as it will multiply rows of data by # of date fields. In the sample data I attached, there are only 50 rows. But the dataset I am working with are 60k rows and increasing. Pivoting these date columns also affect other workbooks (I know, this is a lame excuse). Chris' solution helps greatly. If this is the only solution I will go for it. Thanks again.