Bar Chart Merge 2 columns in a single bar

Question

I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit.

Today I only see this:

Link here

Is opened to everyone, I would like to still see each bar divided with credit and cash — gogasca, Commented May 7, 2019 at 22:58

user0 · Accepted Answer · 2019-05-07 23:12:10Z

1

or use QUERY to group years and output table directly from QUERY:

=QUERY({A2:C}, 
 "select Col1, sum(Col3) 
  where Col1 is not null 
  group by Col1 
  label sum(Col3)''", 0)

answered May 7, 2019 at 23:06

user0

27.1k10 gold badges53 silver badges78 bronze badges

Add a comment |

1 Answer 1