Build a line graph in excel sheet

Question

I have a table with the following data(PFA the image), requirement is to build a line graph with Date in X-Axis and Count in Y-Axis, the Systems should be of each series. When I select the Date column to get the Y-Axis the output is not as expected(PFA the image)

How do I form a line Graph with this data?

Answer 1

If you click on any cell within the table and then select Pivot Chart and Pivot Table you can create what you want. See image. Hope this helps.