2

Instead of having one column for each new "type" below, is there any way to achieve the same result using the non highlighted cells in the image below?

To elaborate, I would like different bar types based on the "type" column, rather than adding a new column for each type.

Is this possible?

different bar types

  • You can get selected range, using this formula: =query({A1:C5},"select Col1, sum(Col3) group by Col1 pivot Col2",1) – Max Makhrov May 31 '16 at 7:21
  • @MaxMakhrov Neat, thanks! Would you mind posting it as an answer so that I can assign the bounty? – Johan May 31 '16 at 8:54
1
+100

You can get selected range, using this formula:

=query({A1:C5},"select Col1, sum(Col3) group by Col1 pivot Col2",1)

The new range can be used to make a chart.

| improve this answer | |

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.