Let us say I have data like this for a spend summary sheet:
I know how to get an aggregate plot by using the
I would like a line plot of multiple lines, now for each category, within the same graph. i.e. for each category, I have a differently colored aggregate line plot. Here for eg, I'd have 3 different colored lines plot, one for
food, one for
coffee and one for
movie, all within the same plot. I'd also like to have a line plot of all categories combined as well, in the same plot. Is such a thing possible in sheets?