How to create a line graph for revenue and different product categories

hi,

i am trying to create a graph in Excel / GSheets that allows me to show revenue on the y axis on a monthly time scale (x axis) per product category. I am failing at this and was wondering what needs to be down in order to get it working.

here you will see a screenshot (as exporting to xlsx messes up the setup) and the test data set attached.

I basically want to have the graph to show a line per product category (a category is found in column "Description") depicting its respective accumulated revenue (amount with tax) on a time scale (invoice date). is this not possible?

actually, you were right. I created a pivot table and could create the desired diagram.

the only thing i had to do, was to reformat the date into text, so that I do not have hundreds of different dates on the x axis in the diagram but a month and year instead.