Stacked Column chart from a single table

I have a single table, sales, that contains all my sales records. I would like to create a single chart that shows stacked colums based on the customers listed in each sales records. Ideally I could select a few customers, add them to a group, and that would be one of the stacks, rinse and repeat. Is this possible in either service or desktop? I have a feeling I could do something on the query level in desktop, but I'd like to start with service.