I'm trying to make a chart in Google Sheets to compare how much two people have paid towards something. What I'm looking for is the chart to have several cost categories (groceries, dining out, pets, etc.) and a person-specific colour for the column in the chart. Whoever is positive in that category, their colour would be used to colour the column in the chart (example: Joe paid $10, Julie paid $20, so Julie is +$10 which would cause the column in that category to be purple or whatever). If the amount paid was even in a category, then there just wouldn't be a column in that category.

I have a column of cells that does this using a =abs(sum(B2-C2)) sort of idea, and then applying a couple formatting conditions based on if $B2>$C2 and vice versa. This works but I'd just like to figure out how to put this into a graph to make it more visual. I realize I can just place the two amount columns side by side in the chart, but I was hoping I could do it this way.


  • Picture attached. What's the best way to attach the actual sheet? – Shane Price Feb 9 '19 at 21:01
  • shared link is now in the post – Shane Price Feb 9 '19 at 21:37
  • you can use Stacked column chart from range A1:B and then add series for C1:C

  • Think I'll have to go that way. Thought there would be a way to accomplish what I had in mind, but I guess not. Thanks – Shane Price Feb 9 '19 at 22:32
  • you had something else in mind? – user0 Feb 9 '19 at 22:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.