3 Replies Latest reply on Sep 7, 2017 6:22 AM by Ray Givler

    How do you split the grand totals into two genders and make them not stacked on one another?

    xiao.tan

      Hey guys,

       

      See below my original table. I have divided my table into six regions/two genders (male-blue and female-red).

      Screen Shot 2017-09-05 at 11.48.04.png

      When I convert the table into a bar graph, the totals stack onto one another, like this:

      I would prefer the total has a similar format as my other six regions though...

      Screen Shot 2017-09-05 at 11.49.37.png

      I'd like the two bars stand side by side like others do. I know there's something wrong with the grand total; maybe I should calculate subtotals based on gender? But how do you do that?

       

      Thank you so much!