I have created a clustered column chart where I inverted value so the series became the "categories" and the dates became series and just manually adjusted the coloring. I have attached an image. Basically, I want to add a line to it, but when I do it compares across dates so is inaccurate. ALso added an image of how the data is set up and the "inverted look to it"
Image of table:
Image of Graph: