I need to create a stacked column chart with Date aggregated on X-axis, and the bars with multiple (dynamically formed?) Category series.

All of the examples out there demonstrate how to create the stacked graphs with the separate columns for each category. Is it possible to achieve the goal without the redundancy of creating another table with categories inlined into dozens of columns? I would really love to avoid that.

I would appreciate the help

CodePudding user response：

try:

=QUERY(A2:C, "select A,sum(B) where A is not null group by A pivot C")