5 Replies Latest reply on Oct 27, 2018 4:44 PM by Shinichiro Murakami

    Complex Stacked Bar Chart - How to create?

    an.dy

      Hi,

      I have a table like:

      1.JPG

       

      And a chart like:

      2.JPG

       

      I need to add +1 column to the current chart (above) for each of the Groups (G1, G2, G3) with SUM of column "Hours" with division (colored) by "EmplGrade" column.

      In excel that would be a pivot table (on the basis of source table above):

      3.JPG

       

      The result should look like:

      4.JPG

       

      Please help me to do that

       

       

      Source TWBX file attached...