7 Replies Latest reply on Feb 15, 2016 1:36 PM by Yuriy Fal

    How do I create a Distribution Differences by Segment chart?

    Richard Gordon

      The following is the process used in Excel starting from a contingency table - the needed outcome is the Distribution Differences by Segment chart below.

       

      Thanking you in advance,

      rg

       

      TableSegment
      Profile123RowTot
      a20120120260
      b4090240370
      c6060240360
      d8030120230
      ColTot2003007201220
      Segment
      Profile123Total
      a10%40%17%21%
      b20%30%33%30%
      c30%20%33%30%
      d40%10%17%19%
      100%100%100%100%
      Segment
      Profile123
      a-11%19%-5%
      b-10%0%3%
      c0%-10%4%
      d21%-9%-2%